""" reports

    Create examples for list.
    Create examples for metric.

"""
#------------------------------------------------------------------------------
#
# Renderers for Lists
# Define how the publication fields are displayed
#
#------------------------------------------------------------------------------
if db(db.renderers).count() == 0:
    db.renderers.insert(id=2,
                        renderer=T('Article'),
                        template="{publications.title}, {publications.first_author} "
                                 "<span style='font-style: italic;'>et al.</span>, "
                                 "{collaborations.collaboration}, "
                                 "{publishers.abbreviation} "
                                 "{publications.volume} ({publications.year}) "
                                 "{publications.pages}",
                        postprocessing='remove_undef',
                        definition=T('Articles published'))

    db.renderers.insert(id=3,
                        renderer=T('Conference'),
                        template="{publications.title}, {publications.authors}, "
                                 "{publications.conference_title}, "
                                 "{publications.conference_town}, "
                                 "{countries.country}, "
                                 "{publications.conference_dates}",
                        postprocessing='highlight_my_speaker',
                        definition=T('Talks or proceedings'))

    db.renderers.insert(id=4,
                        renderer=T('Preprint'),
                        template="{publications.title}, {publications.first_author} "
                                 "<span style='font-style: italic;'>et al.</span>, "
                                 "{collaborations.collaboration}, "
                                 "{publications.preprint}",
                        postprocessing='remove_undef',
                        definition=T('Articles deposited in arXiv not yet published'))

    db.renderers.insert(id=5,
                        renderer=T('Report'),
                        template="{publications.title}, {publications.authors}, "
                                 "{publications.report_numbers}",
                        postprocessing='highlight_my_authors',
                        definition=T('Reports or notes signed by members of the institute'))

    db.renderers.insert(id=6,
                        renderer=T('Report by collaboration'),
                        template="{publications.title}, {publications.first_author} "
                                 "<span style='font-style: italic;'>et al.</span>, "
                                 "{collaborations.collaboration}, "
                                 "{publications.report_numbers}",
                        postprocessing='',
                        definition=T('Reports or notes signed by collaboration(s)'))

    db.renderers.insert(id=7,
                        renderer=T('Thesis'),
                        template="{publications.title}, {publications.authors}, "
                                 "{publications.universities}, {publications.defense}",
                        postprocessing='',
                        definition='PhD Thesis, ...')

#------------------------------------------------------------------------------
#
# Sections for Lists
# Define the relation between the publication category and the renderers
#
#------------------------------------------------------------------------------
if db(db.sections).count() == 0:
    db.sections.insert(id=1,
                       section=T('Articles'),
                       id_renderers=2,
                       category_codes='ACL, ACLN',
                       conditions='',
                       sort_field='submitted',
                       definition='')

    db.sections.insert(id=2,
                       section=T('Preprints'),
                       id_renderers=4,
                       category_codes='PRE',
                       conditions='',
                       sort_field='preprint',
                       definition='')

    db.sections.insert(id=3,
                       section=T('Proceedings'),
                       id_renderers=3,
                       category_codes='ACTI, ACTN',
                       conditions='',
                       sort_field='submitted',
                       definition='')

    db.sections.insert(id=4,
                       section=T('Talks'),
                       id_renderers=3,
                       category_codes='COM',
                       conditions='',
                       sort_field='submitted',
                       definition='')

    db.sections.insert(id=5,
                       section=T('Posters'),
                       id_renderers=3,
                       category_codes='AFF',
                       conditions='',
                       sort_field='submitted',
                       definition='')

    db.sections.insert(id=6,
                       section=T('Reports'),
                       id_renderers=5,
                       category_codes='AP',
                       conditions='id_collaborations < 2',
                       sort_field='submitted',
                       definition='')

    db.sections.insert(id=7,
                       section=T('Reports by collaboration'),
                       id_renderers=6,
                       category_codes='AP',
                       conditions='id_collaborations > 1',
                       sort_field='submitted',
                       definition='')

    db.sections.insert(id=8,
                       section=T('Theses'),
                       id_renderers=7,
                       category_codes='PHD, HDR',
                       conditions='',
                       sort_field='submitted',
                       definition='')

#------------------------------------------------------------------------------
#
# lists
# A series of sections with  grouping criteria
#
#------------------------------------------------------------------------------
if db(db.lists).count() == 0:

    sections = [T('Preprints'),
                T('Articles'),
                T('Proceedings'),
                T('Talks'),
                T('Posters'),
                T('Reports'),
                T('Reports by collaboration'),
                T('Theses')]

    db.lists.insert(id=2,
                    list=T('cat. usual / team / year'),
                    sections=', '.join(sections),
                    axis_level_1='categories',
                    axis_level_2='teams',
                    axis_level_3='publications',
                    granularity_level_1='usual',
                    granularity_level_2='team',
                    granularity_level_3='year',
                    direction_level_3='DESC',
                    definition=T('List shorted by usual category, by team and by year'))

    db.lists.insert(id=3,
                    list=T('cat. AERES / project / year'),
                    sections=', '.join(sections),
                    axis_level_1='categories',
                    axis_level_2='teams',
                    axis_level_3='publications',
                    granularity_level_1='code',
                    granularity_level_2='team',
                    granularity_level_3='year',
                    direction_level_3='DESC',
                    definition=T('List shorted by AERES category, by project and by year'))

#------------------------------------------------------------------------------
#
# Metrics
#
#------------------------------------------------------------------------------
if db(db.metrics).count() == 0:

    db.metrics.insert(id=2,
                      metric=T('cat. usual / year'),
                      axis_column='categories',
                      axis_row='publications',
                      granularity_column='usual',
                      granularity_row='year',
                      definition=T('Count publications by usual category and by year'))

    db.metrics.insert(id=3,
                      metric=T('cat. AERES / year'),
                      axis_column='categories',
                      axis_row='publications',
                      granularity_column='code',
                      granularity_row='year',
                      definition=T('Count publications by AERES category and by year'))