if revision:

            q = q.filter(ChangesetStatus.revision == revision)

        elif pull_request:

            pull_request = self.__get_pull_request(pull_request)

            q = q.filter(ChangesetStatus.pull_request == pull_request)

        else:

            raise Exception('Please specify revision or pull_request')

        q = q.order_by(ChangesetStatus.version.asc())

        return q

    def _calculate_status(self, statuses):

        """

        Given a list of statuses, calculate the resulting status, according to

        the policy: approve if consensus, reject when at least one reject.

        """

        if not statuses:

            return ChangesetStatus.STATUS_UNDER_REVIEW

        if all(st and st.status == ChangesetStatus.STATUS_APPROVED for st in statuses):

            return ChangesetStatus.STATUS_APPROVED

        if any(st and st.status == ChangesetStatus.STATUS_REJECTED for st in statuses):

            return ChangesetStatus.STATUS_REJECTED

        return ChangesetStatus.STATUS_UNDER_REVIEW

    def calculate_pull_request_result(self, pull_request):

        """

        Return a tuple (reviewers, pending reviewers, pull request status)

        Only approve and reject counts as valid votes.

        """

        # collect latest votes from all voters

        cs_statuses = dict()

        for st in reversed(self.get_statuses(pull_request.org_repo,

                                             pull_request=pull_request,

                                             with_revisions=True)):

            cs_statuses[st.author.username] = st

        # collect votes from official reviewers

        pull_request_reviewers = []

        pull_request_pending_reviewers = []

        relevant_statuses = []

        for user in pull_request.get_reviewer_users():

            st = cs_statuses.get(user.username)

            relevant_statuses.append(st)

                pull_request_pending_reviewers.append(user)

        result = self._calculate_status(relevant_statuses)

        return (pull_request_reviewers,

                pull_request_pending_reviewers,

                result)

    def get_statuses(self, repo, revision=None, pull_request=None,

                     with_revisions=False):

        q = self._get_status_query(repo, revision, pull_request,

                                   with_revisions)

        q = q.options(joinedload('author'))

        return q.all()

    def get_status(self, repo, revision=None, pull_request=None, as_str=True):

        """

        Returns latest status of changeset for given revision or for given

        pull request. Statuses are versioned inside a table itself and

        version == 0 is always the current one

        :param repo:

        :param revision: 40char hash or None

        :param pull_request: pull_request reference

        :param as_str: return status as string not object

        """

        q = self._get_status_query(repo, revision, pull_request)

        # need to use first here since there can be multiple statuses

        # returned from pull_request

        status = q.first()

        if as_str:

            return str(status.status) if status else ChangesetStatus.DEFAULT

        return status

    def set_status(self, repo, status, user, comment, revision=None,

                   pull_request=None, dont_allow_on_closed_pull_request=False):

        """

        Creates new status for changeset or updates the old ones bumping their

        version, leaving the current status at the value of 'status'.

        :param repo:

        :param status:

        :param user:

        :param comment:

        :param revision:

        :param pull_request:

        :param dont_allow_on_closed_pull_request: don't allow a status change

            if last status was for pull request and it's closed. We shouldn't

                          %if editable:

                            ${h.radio(name='updaterev', value='', checked=True)}

                          %endif

                        </td>

                        <td colspan="4">${_("Current revision - no change")}</td>

                      %else:

                        <td>

                          %if editable and cs.revision in c.avail_revs:

                            ${h.radio(name='updaterev', value=cs.raw_id)}

                          %endif

                        </td>

                        <td style="width: 120px"><span class="tooltip" title="${h.age(cs.date)}">${cs.date}</span></td>

                        <td>${h.link_to(h.show_id(cs),h.url('changeset_home',repo_name=c.cs_repo.repo_name,revision=cs.raw_id))}</td>

                        <td>

                          <div style="float: right; margin-top: -4px;">

                            %for tag in cs.tags:

                              <div class="tagtag" title="${_('Tag %s') % tag}">

                                ${h.link_to(tag,h.url('changeset_home',repo_name=c.repo_name,revision=cs.raw_id))}

                              </div>

                            %endfor

                          </div>

                          <div class="message" style="white-space:normal; height:1.1em; max-width: 500px; padding:0">${h.urlify_commit(cs.message, c.repo_name)}</div>

                        </td>

                      %endif

                    </tr>

                  %endfor

                </table>

              </div>

              <div class="msg-div">${_("Pull request iterations do not change content once created. Select a revision and save to make a new iteration.")}</div>

              %endif

              <div class="msg-div">${c.update_msg_other}</div>

            </div>

        </div>

      </div>

    </div>

    ## REVIEWERS

    <div style="float:left; border-left:1px dashed #eee">

        <div class="pr-details-title">${_('Pull Request Reviewers')}</div>

        <div id="reviewers" style="padding:0px 0px 5px 10px">

          ## members goes here !

          <div>

            <ul id="review_members" class="group_members">

            %for member,status in c.pull_request_reviewers:

              ## WARNING: the HTML below is duplicate with

              ## kallithea/public/js/base.js

              ## If you change something here it should be reflected in the template too.

              <li id="reviewer_${member.user_id}">

                <div class="reviewers_member">

                    </div>

                  ${h.gravatar_div(member.email, size=14, div_class="reviewer_gravatar gravatar")}

                  <div style="float:left;">

                    ${member.full_name_and_username}

                    %if c.pull_request.user_id == member.user_id:

                      (${_('Owner')})

                    %endif

                  </div>

                  <input type="hidden" value="${member.user_id}" name="review_members" />

                  %if editable:

                  <div class="reviewer_member_remove action_button" onclick="removeReviewMember(${member.user_id})" title="${_('Remove reviewer')}">

                      <i class="icon-minus-circled"></i>

                  </div>

                  %endif

                </div>

              </li>

            %endfor

            </ul>

          </div>

          %if editable:

          <div class='ac'>

            <div class="reviewer_ac">

               ${h.text('user', class_='yui-ac-input',placeholder=_('Type name of reviewer to add'))}

               <div id="reviewers_container"></div>

            </div>

          </div>

          %endif

        </div>

        %if not c.pull_request_reviewers:

        <div class="pr-details-title">${_('Potential Reviewers')}</div>

        <div style="margin: 10px 0 10px 10px; max-width: 250px">

          <div>

            ${_('Click to add the repository owner as reviewer:')}

          </div>

          <ul style="margin-top: 10px">

            %for u in [c.pull_request.other_repo.user]:

              <li>

                <a class="missing_reviewer missing_reviewer_${u.user_id}"

                  user_id="${u.user_id}"

                  fname="${u.name}"

                  lname="${u.lastname}"

                  nname="${u.username}"

                  gravatar_lnk="${h.gravatar_url(u.email, size=28, default='default')}"

                  gravatar_size="14"

                  title="Click to add reviewer to the list, then Save Changes.">${u.full_name}</a>

              </li>

            %endfor