if stat.pull_request:

                pr_id = stat.pull_request.pull_request_id

                pr_repo = stat.pull_request.other_repo.repo_name

            grouped[stat.revision] = [str(stat.status), stat.status_lbl,

                                      pr_id, pr_repo]

        return grouped

    def _repo_size(self):

        from rhodecode.lib import helpers as h

        log.debug('calculating repository size...')

        return h.format_byte_size(self.scm_instance.size)

    #==========================================================================

    # SCM CACHE INSTANCE

    #==========================================================================

    @property

    def invalidate(self):

        return CacheInvalidation.invalidate(self.repo_name)

    def set_invalidate(self):

        """

        Mark caches of this repo as invalid.

        """

    def scm_instance_no_cache(self):

        return self.__get_instance()

    @property

    def scm_instance(self):

        import rhodecode

        full_cache = str2bool(rhodecode.CONFIG.get('vcs_full_cache'))

        if full_cache:

            return self.scm_instance_cached()

        return self.__get_instance()

    def scm_instance_cached(self, cache_map=None):

        @cache_region('long_term')

        def _c(repo_name):

            return self.__get_instance()

        rn = self.repo_name

        if cache_map:

            # get using prefilled cache_map

            invalidate_repo = cache_map[self.repo_name]

            if invalidate_repo:

                invalidate_repo = (None if invalidate_repo.cache_active

                                   else invalidate_repo)

        self.db_repo_list = db_repo_list

        self.repos_path = repos_path

        self.order_by = order_by

        self.reversed = (order_by or '').startswith('-')

        if not perm_set:

            perm_set = ['repository.read', 'repository.write',

                        'repository.admin']

        self.perm_set = perm_set

    def __len__(self):

        return len(self.db_repo_list)

    def __repr__(self):

        return '<%s (%s)>' % (self.__class__.__name__, self.__len__())

    def __iter__(self):

        # pre-propagated cache_map to save executing select statements

        # for each repo

        cache_map = CacheInvalidation.get_cache_map()

        for dbr in self.db_repo_list:

            scmr = dbr.scm_instance_cached(cache_map)

            # check permission at this level

            if not HasRepoPermissionAny(

                continue

            try:

                last_change = scmr.last_change

                tip = h.get_changeset_safe(scmr, 'tip')

            except Exception:

                log.error(

                    '%s this repository is present in database but it '

                    'cannot be created as an scm instance, org_exc:%s'

                    % (dbr.repo_name, traceback.format_exc())

                )

                continue

            tmp_d = {}

            tmp_d['name'] = dbr.repo_name

            tmp_d['name_sort'] = tmp_d['name'].lower()

            tmp_d['raw_name'] = tmp_d['name'].lower()

            tmp_d['description'] = dbr.description

            tmp_d['description_sort'] = tmp_d['description'].lower()

            tmp_d['last_change'] = last_change

            tmp_d['last_change_sort'] = time.mktime(last_change.timetuple())

            tmp_d['tip'] = tip.raw_id

            tmp_d['tip_sort'] = tip.revision

            tmp_d['rev'] = tip.revision

            tmp_d['contact'] = dbr.user.full_contact

            tmp_d['contact_sort'] = tmp_d['contact']

            tmp_d['owner_sort'] = tmp_d['contact']

            tmp_d['repo_archives'] = list(scmr._get_archives())

            tmp_d['last_msg'] = tip.message

            tmp_d['author'] = tip.author

            tmp_d['dbrepo'] = dbr.get_dict()

            tmp_d['dbrepo_fork'] = dbr.fork.get_dict() if dbr.fork else {}

            yield tmp_d

class SimpleCachedRepoList(CachedRepoList):

    """

    Lighter version of CachedRepoList without the scm initialisation

    """

    def __iter__(self):

        for dbr in self.db_repo_list:

            # check permission at this level

            if not HasRepoPermissionAny(

                continue

            tmp_d = {}

            tmp_d['name'] = dbr.repo_name

            tmp_d['name_sort'] = tmp_d['name'].lower()

            tmp_d['raw_name'] = tmp_d['name'].lower()

            tmp_d['description'] = dbr.description

            tmp_d['description_sort'] = tmp_d['description'].lower()

            tmp_d['dbrepo'] = dbr.get_dict()

            tmp_d['dbrepo_fork'] = dbr.fork.get_dict() if dbr.fork else {}

            yield tmp_d

class _PermCheckIterator(object):

    def __init__(self, obj_list, obj_attr, perm_set, perm_checker):

        """

        Creates iterator from given list of objects, additionally

        checking permission for them from perm_set var

        :param obj_list: list of db objects

        :param obj_attr: attribute of object to pass into perm_checker

        :param perm_set: list of permissions to check

        :param perm_checker: callable to check permissions against

        """

    float: right;

    border-left: 1px solid rgba(0,0,0,0.1);

}

#context-pages li.current {

    background: #535353; /* Old browsers */

    background: -moz-linear-gradient(top, #5d5d5d 0%, #484848 100%); /* FF3.6+ */

    background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#5d5d5d), color-stop(100%,#484848)); /* Chrome,Safari4+ */

    background: -webkit-linear-gradient(top, #5d5d5d 0%, #484848 100%); /* Chrome10+,Safari5.1+ */

    background: -o-linear-gradient(top, #5d5d5d 0%, #484848 100%); /* Opera 11.10+ */

    background: -ms-linear-gradient(top, #5d5d5d 0%, #484848 100%); /* IE10+ */

    background: linear-gradient(to bottom, #5d5d5d 0%, #484848 100%); /* W3C */

}

#content #context-pages .icon {

    margin-right: 5px;

}

#header #header-inner #quick li,

#content #context-pages li {

    border-right: 1px solid rgba(0,0,0,0.1);

    border-left: 1px solid rgba(255,255,255,0.1);

    padding: 0;

}

#header #header-inner #quick li:last-child,

#content #context-pages li:last-child {

    border-right: none;

}

#header #header-inner #quick > li:first-child {

    border-left: none;

}

#header #header-inner #quick > li:first-child > a {

    border-radius: 4px 0 0 4px;

}

#header #header-inner #quick a,

#context-pages a,

#context-pages .admin_menu a {

    display: block;

    padding: 0px 10px 1px 30px;

    padding-left: 30px;

    line-height: 35px;

}

#header #header-inner #quick a.thin,

#context-pages a.thin,

      <div class="field">

      %if c.in_public_journal:

        ${h.submit('set_public_%s' % c.repo_info.repo_name,_('Remove from public journal'),class_="ui-btn")}

      %else:

        ${h.submit('set_public_%s' % c.repo_info.repo_name,_('Add to public journal'),class_="ui-btn")}

      %endif

      </div>

     <div class="field" style="border:none;color:#888">

     <ul>

          <li>${_('All actions made on this repository will be accessible to everyone in public journal')}

          </li>

     </ul>

     </div>

    </div>

    ${h.end_form()}

    <h3>${_('Locking')}</h3>

    ${h.form(url('repo_locking', repo_name=c.repo_info.repo_name),method='put')}

    <div class="form">

       <div class="fields">

          %if c.repo_info.locked[0]:

           ${h.submit('set_unlock' ,_('Unlock locked repo'),class_="ui-btn",onclick="return confirm('"+_('Confirm to unlock repository')+"');")}

           ${'Locked by %s on %s' % (h.person_by_id(c.repo_info.locked[0]),h.fmt_date(h.time_to_datetime(c.repo_info.locked[1])))}

          %else:

            ${_('Repository is not locked')}

          %endif

       </div>

       <div class="field" style="border:none;color:#888">

       <ul>

            <li>${_('Force locking on repository. Works only when anonymous access is disabled')}

            </li>

       </ul>

       </div>

    </div>

    ${h.end_form()}

    <h3>${_('Set as fork of')}</h3>

    ${h.form(url('repo_as_fork', repo_name=c.repo_info.repo_name),method='put')}

    <div class="form">

       <div class="fields">

           ${h.select('id_fork_of','',c.repos_list,class_="medium")}

       </div>

           <div class="field" style="border:none;color:#888">

           <ul>

                <li>${_('''Manually set this repository as a fork of another from the list''')}</li>

           </ul>

           </div>

    </div>

    ${h.end_form()}

    <h3>${_('Delete')}</h3>

    ${h.form(url('repo', repo_name=c.repo_info.repo_name),method='delete')}

    <div class="form">

        <div class="fields">

            <div class="field" style="border:none;color:#888">

##              <div class="label">

##                  <label for="">${_('Remove repository')}:</label>

##              </div>

                <div class="checkboxes">

                    ${h.submit('remove_%s' % c.repo_info.repo_name,_('Remove this repository'),class_="ui-btn red",onclick="return confirm('"+_('Confirm to delete this repository')+"');")}

                    %if c.repo_info.forks.count():

                        - ${ungettext('this repository has %s fork', 'this repository has %s forks', c.repo_info.forks.count()) % c.repo_info.forks.count()}

                        <input type="radio" name="forks" value="detach_forks" checked="checked"/> <label for="forks">${_('Detach forks')}</label>

                        <input type="radio" name="forks" value="delete_forks" /> <label for="forks">${_('Delete forks')}</label>

                    %endif

                <div class="tooltip" title="${h.tooltip(','.join([x.username for x in c.pull_request_pending_reviewers]))}">${ungettext('%d reviewer', '%d reviewers',len(c.pull_request_pending_reviewers)) % len(c.pull_request_pending_reviewers)}</div>

            %else:

                <div>${_('Pull request was reviewed by all reviewers')}</div>

            %endif

          </div>

         </div>

         <div class="field">

          <div class="label-summary">

              <label>${_('Origin repository')}:</label>

          </div>

          <div class="input">

              <div>

             ##%if h.is_hg(c.pull_request.org_repo):

             ##  <img class="icon" title="${_('Mercurial repository')}" alt="${_('Mercurial repository')}" src="${h.url('/images/icons/hgicon.png')}"/>

             ##%elif h.is_git(c.pull_request.org_repo):

             ##  <img class="icon" title="${_('Git repository')}" alt="${_('Git repository')}" src="${h.url('/images/icons/giticon.png')}"/>

             ##%endif

              <span class="spantag">${c.pull_request.org_ref_parts[0]}: ${c.pull_request.org_ref_parts[1]}</span>

              <span><a href="${h.url('summary_home', repo_name=c.pull_request.org_repo.repo_name)}">${c.pull_request.org_repo.clone_url()}</a></span>

              </div>

          </div>

         </div>

         <div class="field">

          <div class="label-summary">

          </div>

          <div class="input">

              <div style="white-space:pre-wrap">${h.literal(c.pull_request.description)}</div>

          </div>

         </div>

         <div class="field">

          <div class="label-summary">

              <label>${_('Created on')}:</label>

          </div>

          <div class="input">

              <div>${h.fmt_date(c.pull_request.created_on)}</div>

          </div>

         </div>

      </div>

    </div>

    <div style="overflow: auto;">

      ##DIFF

      <div class="table" style="float:left;clear:none">

          <div id="body" class="diffblock">

              <div style="white-space:pre-wrap;padding:5px">${_('Compare view')}</div>

          </div>

          <div id="changeset_compare_view_content">

              ##CS

             </div>

             <div class="field">

              <div class="label-summary">

                  <label>${_('Clone url')}:</label>

              </div>

              <div class="input ${summary(c.show_stats)}">

                  <input style="width:${'75%' if c.show_stats else '80%'}" type="text" id="clone_url" readonly="readonly" value="${c.clone_repo_url}"/>

                  <input style="display:none;width:${'75%' if c.show_stats else '80%'}" type="text" id="clone_url_id" readonly="readonly" value="${c.clone_repo_url_id}"/>

                  <div style="display:none" id="clone_by_name" class="ui-btn clone">${_('Show by Name')}</div>

                  <div id="clone_by_id" class="ui-btn clone">${_('Show by ID')}</div>

              </div>

             </div>

             <div class="field">

              <div class="label-summary">

                  <label>${_('Trending files')}:</label>

              </div>

              <div class="input ${summary(c.show_stats)}">

                %if c.show_stats:

                <div id="lang_stats"></div>

                %else:

                   ${_('Statistics are disabled for this repository')}

                   %if h.HasPermissionAll('hg.admin')('enable stats on from summary'):

                   %endif

                %endif

              </div>

             </div>

             <div class="field">

              <div class="label-summary">

                  <label>${_('Download')}:</label>

              </div>

              <div class="input ${summary(c.show_stats)}">

                %if len(c.rhodecode_repo.revisions) == 0:

                  ${_('There are no downloads yet')}

                %elif not c.enable_downloads:

                  ${_('Downloads are disabled for this repository')}

                    %if h.HasPermissionAll('hg.admin')('enable downloads on from summary'):

                    %endif

                %else:

                    ${h.select('download_options',c.rhodecode_repo.get_changeset().raw_id,c.download_options)}

                         <span id="${'zip_link'}">${h.link_to(_('Download as zip'), h.url('files_archive_home',repo_name=c.dbrepo.repo_name,fname='tip.zip'),class_="archive_icon ui-btn")}</span>

                    <span style="vertical-align: bottom">

                        <input id="archive_subrepos" type="checkbox" name="subrepos" />

                        <label for="archive_subrepos" class="tooltip" title="${h.tooltip(_('Check this to download archive with subrepos'))}" >${_('with subrepos')}</label>

                    </span>

                %endif

              </div>

             </div>

        </div>

        <div id="summary-menu-stats">

          <ul>

            <li>

               <a class="followers" title="${_('Followers')}" href="${h.url('repo_followers_home',repo_name=c.repo_name)}">

                ${_('Followers')}

                <span style="float:right" id="current_followers_count">${c.repository_followers}</span>

              </a>

            </li>

            <li>

              <a class="forks" title="${_('Forks')}" href="${h.url('repo_forks_home',repo_name=c.repo_name)}">

                ${_('Forks')}

                <span style="float:right">${c.repository_forks}</span>