# HG changeset patch
# User Marcin Kuzminski <marcin@python-works.com>
# Date 1361322912 -3600
# Node ID 1c4505e3be5b9a594e4a65e1545ffd0a015f8bd7
# Parent  cb40b3f6428c42100246fc60f2bdffea91d5474e
show flags, and desc sort pull request based on created_date ref #765

diff -r cb40b3f6428c -r 1c4505e3be5b rhodecode/controllers/admin/settings.py
--- a/rhodecode/controllers/admin/settings.py	Wed Feb 20 01:59:50 2013 +0100
+++ b/rhodecode/controllers/admin/settings.py	Wed Feb 20 02:15:12 2013 +0100
@@ -477,12 +477,16 @@
         c.my_pull_requests = PullRequest.query()\
                                 .filter(PullRequest.user_id ==
                                         self.rhodecode_user.user_id)\
+                                .order_by(PullRequest.created_on.desc())\
                                 .all()
-        c.participate_in_pull_requests = \
+
+        c.participate_in_pull_requests = sorted(
             [x.pull_request for x in PullRequestReviewers.query()\
                                     .filter(PullRequestReviewers.user_id ==
                                             self.rhodecode_user.user_id)\
-                                    .all()]
+                                    .all()],
+                                    key=lambda o: o.created_on, reverse=True)
+
         return render('admin/users/user_edit_my_account_pullrequests.html')
 
     @NotAnonymous()
diff -r cb40b3f6428c -r 1c4505e3be5b rhodecode/model/pull_request.py
--- a/rhodecode/model/pull_request.py	Wed Feb 20 01:59:50 2013 +0100
+++ b/rhodecode/model/pull_request.py	Wed Feb 20 02:15:12 2013 +0100
@@ -55,7 +55,7 @@
         repo = self._get_repo(repo)
         return PullRequest.query()\
                 .filter(PullRequest.other_repo == repo)\
-                .order_by(PullRequest.created_on)\
+                .order_by(PullRequest.created_on.desc())\
                 .all()
 
     def create(self, created_by, org_repo, org_ref, other_repo, other_ref,
@@ -78,7 +78,7 @@
         self.sa.add(new)
         Session().flush()
         #members
-        for member in reviewers:
+        for member in set(reviewers):
             _usr = self._get_user(member)
             reviewer = PullRequestReviewers(_usr, new)
             self.sa.add(reviewer)
@@ -116,6 +116,7 @@
             'pr_url': pr_url,
             'pr_revisions': revisions
         }
+
         notif.create(created_by=created_by_user, subject=subject, body=body,
                      recipients=reviewers,
                      type_=Notification.TYPE_PULL_REQUEST, email_kwargs=kwargs)
diff -r cb40b3f6428c -r 1c4505e3be5b rhodecode/templates/admin/users/user_edit_my_account_pullrequests.html
--- a/rhodecode/templates/admin/users/user_edit_my_account_pullrequests.html	Wed Feb 20 01:59:50 2013 +0100
+++ b/rhodecode/templates/admin/users/user_edit_my_account_pullrequests.html	Wed Feb 20 02:15:12 2013 +0100
@@ -6,6 +6,10 @@
       <li>
         <div style="height: 12px">
           <div style="float:left">
+          %if pull_request.is_closed():
+              <img src="${h.url('/images/icons/lock_go.png')}" title="${_('Closed')}"/>
+          %endif
+          <img src="${h.url('/images/icons/flag_status_%s.png' % str(pull_request.last_review_status))}" />          
           <a href="${h.url('pullrequest_show',repo_name=pull_request.other_repo.repo_name,pull_request_id=pull_request.pull_request_id)}">
           ${_('Pull request #%s opened on %s') % (pull_request.pull_request_id, h.fmt_date(pull_request.created_on))}
           </a>
@@ -29,6 +33,10 @@
       %for pull_request in c.participate_in_pull_requests:
       <li>
         <div style="height: 12px">
+        %if pull_request.is_closed():
+            <img src="${h.url('/images/icons/lock_go.png')}" title="${_('Closed')}"/>
+        %endif
+        <img src="${h.url('/images/icons/flag_status_%s.png' % str(pull_request.last_review_status))}" />          
         <a href="${h.url('pullrequest_show',repo_name=pull_request.other_repo.repo_name,pull_request_id=pull_request.pull_request_id)}">
         ${_('Pull request #%s opened by %s on %s') % (pull_request.pull_request_id, pull_request.author.full_name, h.fmt_date(pull_request.created_on))}
         </a>