{% extends 'base_admin.html.twig' %}
{% block title %}Pub/Titan index{% endblock %}
{% block body %}
    <h1 style="color: red">Pubs / Storage Company</h1>
    <li>
        Each pub/storage company is a separate and distinct companies, with separate financials and investor rights.
    </li>
    <li>
        The EIS rules require that there is no cross linkage and any management agreements etc are standalone.
    </li>
    <br>

    <table class="table">
        <thead>
            <tr>
                <th>Name <span style="color:red"> Hover for address</span></th>
                <th>Total Equity</th>
                <th>My Equity</th>
                <th>Has received EIS certificate</th>

                <th>Share issue date </th>
                <th>Trading start date</th>
                <th>Date EIS restrictions finish </th>
                <th>Valuation (Sep 2020)</th>

                <th>Director1<span style="color:red">  Hover for contact details</span></th>
                <th>Director2<span style="color:red">  Hover for contact details</span></th>
                <th>Director3<span style="color:red">  Hover for contact details</span></th>
                <th>Director4<span style="color:red">  Hover for contact details</span></th>
                <th>Bank<span style="color:red">  Hover for bank details</span></th></th>

                <th>Pref share (% Equity)</th>
                <th>Pref share (£)</th>
                <th>Pref share (Interest rate)</th>
                 {% if is_granted('ROLE_SUPER_ADMIN')%}
                <th>Max Equity % in Pref shares (%)</th>
                {% endif %}
                <th>Pref Share Accrual End</th>
                <th>Default Monies Rec'd Date(%)</th>
                <th> </th>
                <th> </th>
                <th> </th>
                <th> </th>
            </tr>
        </thead>

        <tbody>
        {% for pub in pubs %}
            {% if is_granted('ROLE_MANAGER')  or is_granted('PUB_ACCESS',pub) %}
            {% set pref = pub.totalShares * pub.fundRaisePercent  %}
            <tr>
                <td>
                     {% if is_granted('ROLE_ADMIN') %}
              <a title="{{ pub.address1 }},  {{ pub.address2 }}, {{ pub.city }}, {{ pub.postcode }}" target="_blank" href="{{ path('dashboard_pub_edit', {'slug': pub.slug}) }}">{{pub.name}}</a>
              {% else %}
                  <a title="{{ pub.address1 }},  {{ pub.address2 }}, {{ pub.city }}, {{ pub.postcode }}">{{pub.name}}</a>
                    {% endif %}
                    {% if pub.currentFocus ==1 %} *
                    {% endif %}
                    {% if pub.futureFocus ==1 %} !
                    {% endif %}
              </td>
                <td>{{ pub.totalShares |number_format }}</td>


                <td>{% for share in shares %}
               {% if pub.id == share.pub.id and loggedUser.id ==share.user.id %}
                     {{ share.investmentAmount|number_format }}
               {% endif %}
               {% endfor %}
                </td>

                <td class="text-{{ (pub.isEisApplicationComplete()) ? 'success' : 'danger' }}">{{ pub.isEisApplicationComplete ? 'Yes' : 'No' }}</td>
                <td data-sort="{{ pub.shareIssueDateAt ? pub.shareIssueDateAt|date('Y-m-d') : '' }}">{{ pub.shareIssueDateAt ? pub.shareIssueDateAt|date('M-Y') : '' }}</td>
                <td data-sort="{{ pub.launchAt ? pub.launchAt|date('Y-m-d') : '' }}">{{ pub.launchAt ? pub.launchAt|date('M-Y') : '' }}</td>
                <td class="text-{{ (pub.getEndOfEiS() < date()) ? 'success' : 'danger' }}" data-sort="{{ pub.launchAt ? pub.launchAt|date('Y-m-d') : '' }}">{{ pub.launchAt ? pub.getEndOfEiS()|date('M-Y') : '' }}</td>
                <td>{{ (pub.mtm * 100) |number_format(1, '.') }}%</td>

                <td>
                {% if (pub.director1 is not null) %}
                    {% if pub.director1.linkedIn is not null %}
                    <a title="{{pub.director1.email}}; {{pub.director1.mobile}}">{{pub.director1.fullname}}</a><br>
                    <a target="_blank"  href="{{pub.director1.linkedIn}}}"> <i class="fab fa-linkedin" style="color:blue; text-align: center"></i></a>
                    {% else %}
                    <a title="{{pub.director1.email}}; {{pub.director1.mobile}}" >{{pub.director1.fullname}}</a><br>
                    {% endif %}
                    {% if pub.director1.mobile is not null %}
                    <a target="_blank"  href="https://wa.me/{{ pub.director1.mobile |replace({' ': ''})}}"> <i class="fab fa-whatsapp" style="color:green; text-align: center"></i></a>
                    {% endif %}
                     {% if pub.director1.email is not null %}
                    <a title="{{ pub.director1.email }}" href=mailto:{{ pub.director1.email}}><i class="fa fa-envelope" style="color:gray; text-align: center"></i></a>
                    {% endif %}
                {% endif %}
                </td>
               <td>
                {% if (pub.director2 is not null) %}
                    {% if pub.director2.linkedIn is not null %}
                    <a title="{{pub.director2.email}}; {{pub.director2.mobile}}">{{pub.director2.fullname}}</a><br>
                    <a target="_blank"  href="{{pub.director2.linkedIn}}}"> <i class="fab fa-linkedin" style="color:blue; text-align: center"></i></a>
                    {% else %}
                    <a title="{{pub.director2.email}}; {{pub.director2.mobile}}" >{{pub.director2.fullname}}</a><br>
                    {% endif %}
                    {% if pub.director2.mobile is not null %}
                    <a target="_blank"  href="https://wa.me/{{ pub.director2.mobile |replace({' ': ''})}}"> <i class="fab fa-whatsapp" style="color:green; text-align: center"></i></a>
                    {% endif %}
                     {% if pub.director2.email is not null %}
                    <a title="{{ pub.director2.email }}" href=mailto:{{ pub.director2.email}}><i class="fa fa-envelope" style="color:gray; text-align: center"></i></a>
                    {% endif %}
                {% endif %}
                </td>
                <td>
                {% if (pub.director3 is not null) %}
                    {% if pub.director3.linkedIn is not null %}
                    <a title="{{pub.director3.email}}; {{pub.director3.mobile}}" >{{pub.director3.fullname}}</a><br>
                    <a target="_blank"  href="{{pub.director3.linkedIn}}}"> <i class="fab fa-linkedin" style="color:blue; text-align: center"></i></a>
                    {% else %}
                    <a title="{{pub.director3.email}}; {{pub.director3.mobile}}" >{{pub.director3.fullname}}</a><br>
                    {% endif %}
                    {% if pub.director3.mobile is not null %}
                    <a target="_blank"  href="https://wa.me/{{ pub.director3.mobile |replace({' ': ''})}}"> <i class="fab fa-whatsapp" style="color:green; text-align: center"></i></a>
                    {% endif %}
                     {% if pub.director3.email is not null %}
                    <a title="{{ pub.director3.email }}" href=mailto:{{ pub.director3.email}}><i class="fa fa-envelope" style="color:gray; text-align: center"></i></a>
                    {% endif %}
                {% endif %}
                </td>
               <td>
                {% if (pub.director4 is not null) %}
                    {% if pub.director4.linkedIn is not null %}
                    <a title="{{pub.director4.email}}; {{pub.director4.mobile}}" >{{pub.director4.fullname}}</a><br>
                    <a target="_blank"  href="{{pub.director4.linkedIn}}}"> <i class="fab fa-linkedin" style="color:blue; text-align: center"></i></a>
                    {% else %}
                    <a title="{{pub.director4.email}}; {{pub.director4.mobile}}" >{{pub.director4.fullname}}</a> <br>
                    {% endif %}
                    {% if pub.director4.mobile is not null %}
                    <a target="_blank"  href="https://wa.me/{{ pub.director4.mobile |replace({' ': ''})}}"> <i class="fab fa-whatsapp" style="color:green; text-align: center"></i></a>
                    {% endif %}
                     {% if pub.director4.email is not null %}
                    <a title="{{ pub.director4.email }}" href=mailto:{{ pub.director4.email}}><i class="fa fa-envelope" style="color:gray; text-align: center"></i></a>
                    {% endif %}
                {% endif %}
                </td>
                <td style="text-align: center"> <a title="Beneficiary: {{pub.bankAccountName}}; Sort code: {{pub.bankSortCode}}; Account number: {{pub.bankAccountNumber}}" ><i class ="fa fa-info-circle"></i></a></td>
                <td> <a target="_blank" class href="{{ pub.prefShareLink}}">{{ (pub.fundRaisePercent * 100) | number_format (2, '.') }}% </a> </td>
                <td> {{ pref | number_format }}</td>
                <td> {{ (pub.prefShareInterestRate *100) |number_format(2, '.') }}%</td>

                   {% if is_granted('ROLE_SUPER_ADMIN')%}
                <td> {{ pub.maxPercentEquityInExcessPrefShares *100}}%</td>
                   {% endif %}

               <td data-sort="{{ pub.prefShareAccrualEndDate ? pub.prefShareAccrualEndDate|date('Y-m-d') : '' }}">{{ pub.prefShareAccrualEndDate ? pub.prefShareAccrualEndDate|date('d-M-Y') : '' }}</td>
               <td data-sort="{{ pub.prefShareDefaultMoniesReceivedDate ? pub.prefShareDefaultMoniesReceivedDate|date('Y-m-d') : '' }}">{{ pub.prefShareDefaultMoniesReceivedDate ? pub.prefShareDefaultMoniesReceivedDate|date('d-M-Y') : '' }}</td>

                <td><a target="_blank" class="btn btn-outline-primary" href="{{ path('dashboard_pub_show_questions', {'slug': pub.slug}) }}"> QnA </a></td>
                <td><a target="_blank" class="btn btn-info" href="{{pub.website}}">Website</a></td>
                <td><a title="{{ pub.companyNumber}}" target="_blank" class="btn btn-info" href="{{pub.companiesHouseUrl}}">CH</a></td>
                <td><a class="btn btn-primary" href="{{ path('dashboard_pub_show_shares', {'slug': pub.slug}) }}">Share register</a></td>
            </tr>
            {% endif %}
        {% else %}

        {% endfor %}
        </tbody>
    </table>

    <br>
    <br>
    <br>
    <a target="_blank" class="btn btn-danger" href="https://beta.companieshouse.gov.uk/officers/yTVU_IYpXUy2gWjcVAahwNCgldA/appointments">James McCulloch companies</a>
    <a target="_blank" class="btn btn-danger" href="https://beta.companieshouse.gov.uk/company/10433923">Harcourt Inns</a>
    <a target="_blank" class="btn btn-danger" href="https://beta.companieshouse.gov.uk/company/11885258">Harcourt Investments Limited</a>
    <a target="_blank" class="btn btn-danger" href="https://beta.companieshouse.gov.uk/company/12357554">Star & Garter</a> <br><br>
    <a target="_blank" class="btn btn-info" href="https://beta.companieshouse.gov.uk/company/07706480">Ducalian Capital Limited</a>
    <a target="_blank" class="btn btn-info" href="https://beta.companieshouse.gov.uk/company/06274876">Ducalian Limited</a><br><br>

    <h1>
    {% if is_granted('ROLE_SUPER_ADMIN') %}
    <a target="_blank" class="btn btn-info" href="{{ path('shareregister_index') }}">Share register - All</a>

    <a class="btn btn-primary" href="{{ path('dashboard_pub_new') }}">Create new</a>
    {% endif %}
{% endblock %}
   {% block datatable %}
       <script>
           $(document).ready( function () {
               $('.table').DataTable({
                   'pageLength': 50,
                    "paging":   false,
                    "searching":   false,
                    "bInfo": false,
                   "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 %}