# You must use a tab-size of 4 spaces to edit this file.
---
zenario__users:
    nav:
        sign_in_log:
            ord: 7
            label: User sign-in log
            tooltip: Log recording when extranet users have signed in to the extranet
            panel:
                title: User sign-in log
                notice:
                    show: false
                    type: information
                    message: ''
                db_items:
                    table: '[[DB_PREFIX]]user_signin_log AS usl LEFT JOIN [[DB_PREFIX]]users AS u ON usl.user_id = u.id'
                    id_column: usl.id
                    group_by: >
                        usl.id
                refiners:
                    user:
                        sql: "u.id=[[REFINER_ID]]"
            
                columns:
                    Time:
                        title: Time accessed
                        db_column: usl.login_datetime
                        format: datetime_with_seconds
                        show_by_default: true
                        width: large
                    User_Id:
                        width: small
                        title: User ID
                        db_column: "IFNULL(u.id, CONCAT(usl.user_id, ' (account deleted)'))"
                        align_right: true
                        show_by_default: true
                    User_Identifier:
                        width: medium
                        title: User Identifier
                        db_column: "IFNULL(u.identifier, CONCAT(usl.user_id, ' (account deleted)'))"
                        show_by_default: true
                    Screen_name:
                        width: small
                        title: Screen name
                        db_column: u.screen_name
                        searchable: true
                    First_Name:
                        width: small
                        title: First name
                        db_column: u.first_name
                        hidden: true
                        searchable: true
                    Last_Name:
                        width: small
                        title: Last name
                        db_column: u.last_name
                        hidden: true
                        searchable: true
                    User_Name:
                        width: small
                        title: Name
                        show_by_default: true
                    Email:
                        width: large
                        title: Email Address
                        db_column: u.email
                        show_by_default: true
                        searchable: true
                    Client_Browser:
                        title: Client Browser
                        width: large
                        db_column: "CONCAT(usl.platform, ' ', usl.browser, ' ', usl.browser_version)"
                        show_by_default: true
                        searchable: true
                
                default_sort_column: Time
                label_format_for_grid_view: |
                    [[Time]] [[Screen_name]]
                default_sort_column: Time
                default_sort_desc: true
                item:
                    css_class: log sign_in_log
                no_items_message: |
                    No user sign-ins have been logged. To log sign-ins, please go to Configuration->Site Settings, open the Data Protection interface, and enable sign-in logging.
    
    panels:
        users:
            item_buttons:
                sign_in_log:
                    ord: 0.1
                    parent: view_dropdown
                    hide_in_select_mode: true
                    label: This user's sign-in log
                    link:
                        path: zenario__users/nav/sign_in_log/panel
                        refiner: user