{% extends 'base_admin.html.twig' %}

{% block title %}Pub index{% endblock %}

{% block body %}
    <h1>Investor Representation</h1>

    <br><br><br>
    <table class="table">
        <thead>
            <tr>
                <th>Pub</th>
                <th>Equity</th>
                <th>Shareholders</th>

                <th>Contacted #</th>
                <th>Contacted £</th>
                <th>Contacted %</th>

                <th>Valid email #</th>
                <th>Valid email £</th>
                <th>Valid email %</th>

                <th>SAG #</th>
                <th>SAG £</th>
                <th>SAG %</th>

                <th>Identified #</th>
                <th>Identified £</th>
                <th>Identified %</th>

                <th>On-side #</th>
                <th>On-side £</th>
                <th>On-side %</th>

                <th>Target #</th>
                <th>Target £</th>
                <th>Target %</th>

                <th>Known & Target & On-side %</th>

            </tr>
        </thead>
        <tbody>
        {% for pub in pubs %}
            {% set stats = pubsStats[pub.slug] %}
            <tr>
                <td>{{ pub.name }}</td>
                <td>{{ stats['total_shareholder'] | number_format() }} </td>
                <td>{{ stats['total_shares'] | number_format() }} </td>

                <td>{{ stats['shareholders_contacted'] | number_format() }}</td>
                <td>{{ stats['shareholders_amount_contacted'] | number_format() }}</td>
                <td>{{ stats['shareholders_contacted_percentage'] | number_format(2, '.') }} %</td>

                <td>{{ stats['shareholders_valid_email'] | number_format() }}</td>
                <td>{{ stats['shareholders_amount_valid_email'] | number_format() }}</td>
                <td>{{ stats['shareholders_valid_email_percentage'] | number_format(2, '.') }} %</td>

                <td>{{ stats['shareholders_SAG'] | number_format() }}</td>
                <td>{{ stats['shareholders_amount_SAG'] | number_format() }}</td>
                <td>{{ stats['shareholders_SAG_percentage'] | number_format(2, '.') }} %</td>

                <td>{{ stats['shareholders_identified'] | number_format() }}</td>
                <td>{{ stats['shareholders_amount_identified'] | number_format() }}</td>
                <td>{{ stats['shareholders_identified_percentage'] | number_format(2, '.') }} %</td>

                <td>{{ stats['shareholders_onside'] | number_format() }}</td>
                <td>{{ stats['shareholders_amount_onside'] | number_format() }}</td>
                <td>{{ stats['shareholders_onside_percentage'] | number_format(2, '.') }} %</td>

                <td>{{ stats['shareholders_target'] | number_format() }}</td>
                <td>{{ stats['shareholders_amount_target'] | number_format() }}</td>
                <td>{{ stats['shareholders_target_percentage'] | number_format(2, '.') }} %</td>


                <td>{{ stats['shareholders_combined_percentage'] | number_format(2, '.') }} %</td>

            </tr>
        {% else %}
            <tr>
                <td colspan="11">no records found</td>
            </tr>
        {% endfor %}
        </tbody>
    </table>

{% endblock %}

   {% block datatable %}
       <script>
           $(document).ready( function () {
               $('.table').DataTable({
                   'pageLength': 50,
                   "order": [[ 0, 'asc' ], [ 1, 'desc' ]]
               });

               function detectMob() {
                   return ( ( window.innerWidth <= 800 ) && ( window.innerHeight <= 600 ) );
               }
               var isMobile = detectMob();
               if(isMobile) {
                   $('body').addClass('mobile');
               }
           });

       </script>
   {% endblock datatable %}