# HG changeset patch
# User jittat <jittat@6386c4cd-e34a-4fa8-8920-d93eb39b512e>
# Date 2008-04-26 08:15:19
# Node ID c7b351b3b685fa8bc247f0d39621d1035fba1e9a
# Parent  8fbc279e88758a5497269b1bfbe1ef0355b022ba

[web] better ui for announcement and prob stat

git-svn-id: http://theory.cpe.ku.ac.th/grader/web/trunk@195 6386c4cd-e34a-4fa8-8920-d93eb39b512e

diff --git a/app/controllers/announcements_controller.rb b/app/controllers/announcements_controller.rb
--- a/app/controllers/announcements_controller.rb
+++ b/app/controllers/announcements_controller.rb
@@ -8,7 +8,8 @@
   # GET /announcements
   # GET /announcements.xml
   def index
-    @announcements = Announcement.find(:all)
+    @announcements = Announcement.find(:all,
+                                       :order => "created_at DESC")
 
     respond_to do |format|
       format.html # index.html.erb
diff --git a/app/models/submission.rb b/app/models/submission.rb
--- a/app/models/submission.rb
+++ b/app/models/submission.rb
@@ -30,7 +30,8 @@
 			   "(SELECT MAX(id) FROM submissions AS subs " +
 			   "WHERE subs.user_id = submissions.user_id AND " +
                            "problem_id = " + problem_id.to_s + " " +
-			   "GROUP BY user_id)")
+			   "GROUP BY user_id) " +
+                           "ORDER BY user_id")
   end
 
   def self.find_last_for_all_available_problems(user_id)
diff --git a/app/views/announcements/index.html.erb b/app/views/announcements/index.html.erb
--- a/app/views/announcements/index.html.erb
+++ b/app/views/announcements/index.html.erb
@@ -5,6 +5,8 @@
 
 <h1>Listing announcements</h1>
 
+<%= link_to 'New announcement', new_announcement_path %>
+
 <table>
   <tr>
     <th>Body</th>