pavel-anisimov / goalsplus Goto Github PK

Need to copy a rules page from the old project.
At this point rules are not explained.

Create a system where user can get awards (serious and funny ones).

Like if a user scores 3 points 3 times in a row, be will get a Ronaldo award
Not getting points 5 times in a row - Kerzhakov award
Scoring in a row for a longest period (some other award).

Awards should represent icons and show next to a users's name

Edit score form is in raw code without styling.
Need to fix it with accordance with of template layout

Fix the navbar (with CanCan)

User registers on the page and gets his pending account with guest permissions.
Admin gets a notification that there is a new user. He can aprove or decline the new user.

A page where user can see only his guesses

Man Utd vs Fulham (3pts)
AFC Wrexham vs Newport County (1pt)

Need a page with "about" info.

about author
about the project
technical info

Admin panel has a blank page. Need to populate it with admin tools

Create initial standings page:

1. Standings by points
2. Standings by last 5 form

Migrate to DigitalOcean VPS. Park a new domain.

For the front page create a jQuery generated news block changing dynamically (rotating or something).

Need to update a template for all devise forms

Some forms (like submit the score) must redirect to self (since they are ajax forms).

Change in controller JSON to be the first respond.

Display returned messages (errors or confirmations)

Create and deploy a beta version for public testing

Need to update a template for all devise forms

Make sure, that admin, user and guest have their preveleges working for all palges

Edit the match form is in raw code without styling.
Need to fix it with accordance with of template layout.
Need to link it with other data (stadium -> city -> tz etc)

Make sure that when something interesting is happening:

• like somebody scored more then 3 points
• Somebody scored an award
• New match has been added
• Somebody new has joined the project

When new user registers, an admin should receive an email with notification.

Create an automatic news auto-generation.
For example, when a new person joins the system, a news is generated.
When somebody scores 3 points or more, a news is generated.
When the leader in the table is changed, the news is generated for that.

Create an ability to add team and club logos, national flags so they are displayed next to the team name.

Make sure that users are able to create their own avatars with size 100x100 or something.

They should be able to upload an image from the settings page, and the avatar should be renamed to their user id name with png extension. Like 21.png

Create a message board where users will be able to submit their comments.

By default user has setting id = 1 (default setting).

Until he goes and fixes his settings, he should se a message on top with reminder to fix settings.

Add jQuery script to open 'submit the score' form from the same page where the matches are.

To see the full stats, the user will still have to go to the show match view.

Need to update last form table.

Here's a relevant script:

select u.id,
u.screen_name,
max(case when rn=1 then points end) m1,
max(case when rn=2 then points end) m2,
max(case when rn=3 then points end) m3,
max(case when rn=4 then points end) m4,
max(case when rn=5 then points end) m5,
SUM(m.points) pts
from (select users.id id, screen_name from users, settings where users.setting_id = settings.id) u
join (
select
user_id,
points,
@rn:=IF(user_id=@prevUserId,@rn+1,1) rn,
@prevUserId:=user_id,
m_date
from
(select m.id match_id, guesses.id as g_id, points, user_id, date m_date
from guesses, (select * from matches where date < '2014-05-13 13:17' order by date DESC limit 5) m
where guesses.match_id = m.id order by m.date) t
join (select @prevUserId:= 0, @rn:= 0) g
order by user_id, m_date desc
) m on u.id = m.user_id
group by u.id, u.screen_name
order by pts DESC, m1 DESC, m2 DESC, m3 DESC, m4 DESC, m5 DESC

Create a model and controller for the news page