Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Ruby JavaScript
branch: master

This branch is 4 commits ahead, 76 commits behind frankmt:master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
app
config
db
doc
features
lib
public
script
spec
vendor
.gitignore
Capfile
README
Rakefile
rerun.txt

README

== Agile Brazil 2010 Submission System

Run rake gems to list the libraries being used to build this app.

For project progress and stories: http://www.pivotaltracker.com/projects/48585

select votes.*, users.*, session_aggr.cnt AS first_author_count, session_aggr_2.cnt AS second_author_count, comment_aggr.cnt AS comment_count
from votes
inner join users on users.id = votes.user_id
left outer join (SELECT author_id, count(*) AS cnt FROM sessions GROUP BY author_id) AS session_aggr ON session_aggr.author_id = users.id
left outer join (SELECT second_author_id, count(*) AS cnt FROM sessions GROUP BY second_author_id) AS session_aggr_2 ON session_aggr_2.second_author_id = users.id
left outer join (SELECT user_id, count(*) AS cnt FROM comments GROUP BY user_id) AS comment_aggr ON comment_aggr.user_id = users.id
where user_ip IN (
select user_ip from votes
group by user_ip
having count(user_ip) > 1)
order by votes.user_ip, votes.created_at

TODO:

 --- BUGS
 * new_session_review(nil) works iff locale is not explicit
 * Sorting by author, second author and track sort weirdly (using ids instead of names) on organizer_sessions
 * Sorting by session sorts weirdly (using ids instead of names) on reviewer_reviews
 --- High priority
 * Deadline for adding/editing reviews
 * Sort by author, second_author and track on reviewer_reviews
 --- Medium term
 * Improve sorting by reviews count using SQL (currently Ruby done)
 * Create time slots on agenda
 * Organizers can create program
 * Organizers can add note before publishing reviews to author
 * Author can see anonymous reviews
 * Allow reviewers to remove a session from the list of session they can review
 --- Lower priority
 * Display progress bar with total number of reviews for reviewer
 * Reviewer can edit a review
 * Voting results
 * Search submissions
 * Manage Roles (admin only)
 - Validate foreign_key references
 - send emails on background job (delayed_job?)
 * Upload picture to profile
 * Forbid to add an organizer to a track in which he has submissions (main or second author)
 * Allow reviewers who removed a session from their list of session to re-add those sessions

IN PROGRESS:

 * [task] -- [person]
 * Listing of reviews of each proposal -- Hugo
 
DONE:

 * Cucumber features -- Ricardo Almeida
 * Sorting proposals by recommendation and session id in the reviewer listing -- Hugo
 * Sorting proposals by any field in the organizer listing -- Hugo
 * Do not paginate reviewers on organizer's view -- Hugo
 * Adding reviewer review count to list of reviewers -- Hugo
 * Adding reviewer preference to list of reviewers -- Hugo
 * Display progress bar with total number of reviews -- Danilo
 * Reviewer can't choose preference on track(s) he/she is organizing -- Danilo
 * 'My reviews' listing for each reviewer -- Hugo
 * Improve new review form layout -- Hugo/Danilo
 * Session state machine -- Danilo
 * Organizers can view list of reviewers -- Danilo
 * Reviewer can view a list of sessions to review (missing limit by number of reviews) -- Danilo
 * Improve show review layout -- Hugo
 * Reviewer can add a review -- Hugo
 * Add link to create a review in the reviewer session listing -- Danilo
 * Change reviews to refer to a user instead of a reviewer -- Danilo
 * Include the user id while creating a new review (currently forbidding to save) -- Danilo
 * Add restriction access to review new and create -- Danilo
 * Reviewer can view a list of sessions to review -- Danilo
 * Organizers can view list of session on track -- Danilo
 * Organizer can cancel session on his/her track -- Danilo
 * Javascript enhancements on user invitation preferences page -- Danilo
 * Reviewer provides preferences when accepting invitation -- Danilo
 * Reviewer can accept/reject invitation -- Danilo
 * Organizers can remove reviewer -- Danilo
 * Organizers can invite reviewers (send e-mail) -- Danilo
 * Admin can manage organizers -- Danilo
 * Organizer role for a track -- Danilo
 * Changing color scheme and logo -- Danilo
 * Change vote -- Hugo
 * Voting deadline -- Danilo
 * Logo voting -- Danilo
 * Simplified registration for voters -- Danilo
 * Add comments -- Danilo
 - auto-select duration/session type if track is experience reports -- Danilo
 - Melhorias de usabilidade com javascript (por exemplo, desabilitando campos desnecessários ou escolhendo valores padrão quando não tem escolha) -- Danilo
 - allow resizing of long text fields -- Danilo
 - auto-focus on form field -- Danilo
 - Error page for 404/500 -- Danilo
 - Sending email as multipart (content-type) with html and plain txt version -- Danilo
 * E-mail when session is submitted -- Danilo
 * Password reset -- Danilo
 - Add error summary (or flash message) when validation fails (to avoid scrolling and missing error) -- Danilo
 - Translate homepage to english -- Danilo
 * Sending e-mail when user registers -- Danilo
 * Configure production environment (preciso da ajuda do Hugo pra configurar o Dreamhost e criar o BD) -- Hugo/Danilo
 - link keywords to search on submissions -- Danilo
 - Contact email address on footer -- Danilo
 - mini-help with wiki-syntax example -- Mari/Danilo
 - link on help text opens in a new window to avoid losing form data -- Danilo
 - link to rules page is broken (link to call for papers page?) -- Danilo
 - Guidelines static-page -- Mari/Danilo
 - O campo de mini-cv deveria ter um número mínimo de caracteres (quantos? e os outros campos longos?) -- Danilo
 - Improve Layout (CSS, I'm not an expert on design, but I think the markup is pretty decent) -- Mari/Hugo
 - Added next important deadline to layout -- Mari/Hugo
 - Improved text on home-page -- Mari/Hugo
 - Wiki-like syntax on long text fields -- Hugo
 * Add country to user (Brazil default) so state becomes optional if not brazil -- Danilo
 - Campo: limite de participantes (somente numérico? obrigatório pra qual tipo de sessão?) -- Danilo
 * Limit edit by deadlines -- Danilo
 * Edit session -- Danilo
 - Styling and i18n for pagination -- Danilo
 * Edit user profile -- Danilo
 * Authorization model (can-can gem) -- Danilo
 * Add role to user -- Danilo
 * My submissions -- Danilo
 - Improving URLs (permalink) -- Danilo
 * Keywords -- Danilo
 * Tagging -- Danilo
 - Spinner while autocomplete is loading -- Danilo
 * Second author -- Danilo
 * Reference data: SessionLevel (beginner, practitioner, experienced) -- Danilo
 * Reference data: SessionDuration (45 / 90 minutes) -- Danilo
 * Reference data: SessionType (tutorial, talk, workshop) -- Danilo
 * Reference data: Track (engineering, management, experience report, general interest) -- Frank/Danilo
 * Resource: Session -- Danilo
 * User profile page -- Danilo
 * Capistrano deploy recipes (staging) -- Danilo
 * Add attributes to user (mini-bio, etc...) -- Danilo
 * Create database (UTF-8 encoding) -- Danilo
 * Setup Rails project (gems/plugins) -- Danilo
 * Simple Authentication (create user/login/logout) -- Danilo
 * I18N support (available in :en and :pt, :pt default) -- Danilo
 * Homepage -- Danilo
 * Github project -- Frank

BUGS:

* After I have logged in, I then change my password, when I click on update, I am logged out....

* After I have logged in, I should not see "Register a new account" on the main text, How to submit a session to Agile Brazil 2010.  The registered user should not be asked to register again, in other words. [won't fix]
* Should not allow numerical characters in City field. [won't fix]
* Should not allow numerical characters in First name and Last name fields. [won't fix]
* Should not allow tags, for example, <h1>, to be inserted in any field. [won't fix]
* Should not allow !@£$%^&*() characters in First name and Last name fields [won't fix]
* Edit profile page: should not be able to insert <H1> / <H2> tags in Bio field. [won't fix]
* Should allow / not allow numbers and characters in target audience field? [won't fix]

FIXED:
* Session ID on the reviewer session listing is wrong [column removed] -- Hugo
* Login brings you to the review count js [fixed] -- Hugo/Danilo
* Link to "My reviews" is bugged when locale is set [fixed] -- Hugo
* If I try to log in using an invalid account, I get an error message "is not valid" - could that be aligned under the user name text field? [fixed]
* How to submit a session > "Create a user" link on the main page and "Register new
account" link on the left hand column.  They point to the same link but used different words.  Should we use the same words?  i.e. stick to one. [fixed]
* Register new account button does not go anywhere [fixed]
* When I press log in without entering any username or password, I get the error message "You did not provide any details for authentication".  I then click on register new account link (or create a user link), I go to a different page, but the error message is still there.  I should not see this error message. [fixed]
* Error message for Username
"should use only letters, numbers, spaces, and .-_@ please" needs to change to
"please use only letters, numbers, spaces and . - _ @" [fixed]
* Error message for password field
"doesn't match confirmation" change to
"passwords do not match" [fixed]
* When I update my profile, I see the message "User was successfully updated." this needs to say "Profile was successfully updated". [fixed]
* After I have logged in, "Propose a session" needs to be an active link, and not just plain text [fixed]
* Second author's username, description: "Please provide the second author's username on this field." change to "Please provide the second author's username in this field." [fixed]
* The log out link is not very visible, at the moment it is buried between the links on the left hand column. [fixed]
* Links on the left hand side: Should we rename "account profile" to profile?  My account profile and Edit my account profile sounds too long winded? My profile & Edit my profile seem shorter & neater? [fixed]
* After I have logged in, I then change my password, when I click on update, I am logged out.... But I should not see session proposals link on the page (because I would get this error message too "You must first log in or sign up before accessing this page.") [fixed]
* When I have logged in, I can click on the create a user link, but then I an error message "This page is only available when you're logged out.".  Perhaps I shouldn't even see this link in the first place? [fixed]
* Should we trim leading & trailing spaces in all text fields? For example:  "     Jenny     " is valid [fixed]
* Given I have created a user "user1", I should not be able to create another user "user1 " with a space behind it. (Usernames should not have a trailing space) [fixed]
* Also, remove the space before colon [fixed]
* State field should not be a mandatory field.  What if I am travelling from out of Brazil? [fixed]
* Should not allow <tags> to be entered / rendered on submit proposals form. [fixed]
* Should we allow links to be in the submit proposals form? That are not website forms?  I could link to google.com, for example. [fixed]
* Should max number of character for username be 100?  Is this feasible? [fixed]
* More spacing in Session Track, Session Types and Audience Levels pages?  It was slightly difficult to read the 4 bullet points when they are all squashed together [fixed]
? After I have edited my profile (changed password), when I click on Update profile, I should not be logged out.  But if I have only changed, say, Bio section and updated, it does not log me out. [fixed]
* There needs to be more white space before the Copyleft / footer statement.  Ideally the copyleft should always align at the bottom of the page, and not at the end of the text. [fixed]
* Need more spacing on the "How to submit a session to Agile Brazil 2010" page between paragraphs [fixed]
* The date formats expressed on the site do not follow the same rule.  At the top-left corner, it is YYYY-MM-DD, but in body text, it is DD/MM/YYYY. [fixed]
* Create a session proposal: When I click on the link under the second author's field, http://agilebrazil2010.dtsato.com/users/new?locale=en, I get an error message "This page is only available when you're logged out."  This should not happen and I should see all registered users without having to log out.  At least I think this is the intended use for this link. [fixed]
* When I create a new user, and I enter an email address of an existing user, the error message should not be "has already been taken".  It should be "Another user has an account with the same email address.  Please enter another." .... or some sort. [fixed]
* I should not be able to enter letters in Phone field. [fixed]
* I should not be able to enter non-letter and non-numerical characters in Phone field.  i.e. !@£$%^&*?/<>\|'"`~§±€ BUT + () and . is acceptable. [fixed]
* When you are viewing a particular proposal, Should general information and keyword be smaller, in terms of font-size? [fixed]
* Wrap text? [See AgileBrazilQA-01.tiff] [fixed]
* State field on the create user form: still does not have a "Not applicable" value in the drop down. [fixed]
* When creating a session proposal, should there be some help / description in Target audience field? [fixed]
* Agile Brazil 2010 is inviting the members of the community .... [JW] Remove the word "the" in this sentence. [fixed]
* Once you voted ... [JW] Add word: "Once you have voted ..." [fixed]
* Should not see "Are you sure you want to vote for logo undefined? You are only allowed to vote once." message, when the user did not select a logo and clicked on the Vote button. [fixed]
* The site allows the user to vote as many times as they like before the closing date.  Therefore there is no need to warn users (on the confirmation message) that they are only allowed to vote once. [fixed]
* Changing your vote: once a user has voted for a logo, they can remain on the same page, and click on "Change vote" for as many times as they like. [fixed]
* If a user has voted for logo 1, they then click on logo 2 and Change vote button, but at the confirmation message click on "Cancel" -- the green box should remain on logo 1 and NOT logo 2.  The button text should only be enabled when the user makes a different selection. [fixed]
* Why is there no indication whether a user has voted or not?  It looks like we are forever asking for the user to cast a vote when they have already done so.  Can we say something like "You have voted", somewhere on the page?  If not, it is okay to have the green box on the logo the user has voted. [fixed]
* To edit the session, the author has to click on the "Edit" link that is next to their name (also as a link).  This is slightly confusing as it appears to be a link to edit the author profile, or it could be editing the session page.  Suggested solution: use link text "Edit session" to prevent ambiguity. [fixed]
* Exception when inviting user with simple profile to be a reviewer/organizer [fixed]
* Adding review should call session.reviewing to change it's state [fixed]
* Cannot review same session again (validation on review and permission) [fixed]
* Reviewer can't choose preference on track(s) he/she is organizing [fixed]
* Reviewer can review any session (even if not part of his preferences) [fixed]
* Organizer can cancel already cancelled session [fixed]
* Review count on reviewers page is wrong [fixed]
* Progress bar changes color with progress [fixed]
Something went wrong with that request. Please try again.