{% extends 'base_admin.html.twig' %}
{% block title %}Fund Raise - {{ shareholder.fullname }} {% endblock %}
{% block body %}
    <div class="row">
        <div class="col-md-4">
            <h1 style="color: red">Preference Share Fund Raise</h1>
            <ul>
                <li>The Pref Share "Ask" is the proportion of the total initial investment that is being sought in Pref
                    Shares now.
                </li>
                <li>All investors are guaranteed to be allocated their pro-rata shares of the "Ask" amount as a
                    minimum.
                </li>
                <li>If some investors choose not to invest in the Pref Shares (or under-subscribe for their allocation),
                    their remaining allocation will be made available to other investors.
                </li>
                <li>The interest rate on these "Excess" Pref Shares will pay an additional 3% of interest, but will be
                    the first to be repaid.
                </li>
                <li>The "Excess" Pref Shares will be allocated to the investors pro-rata to the original investment
                    amount up to the amount subscribed.
                </li>
                <li>You can amend your contribution at any time up to the closing date, but we would appreciate a swift
                    indication as soon as possible.
                </li>
            </ul>
        </div>
        <hr>

        <div class="col-md-8">
            <table class="table">
                <thead>
                <tr>
                    <th>Pub</th>
                    <th>"Ask" (% of initial investment)</th>
                    <th>Interest rate ("Standard")</th>
                    <th>Interest rate ("Excess")</th>
                    <th>Background letters</th>
                    <th class="bg-warning"><span class="text-danger"><b>Application Forms</b></span></th>
                    <th>Beneficiary</th>
                    <th title="23-05-80 is Metro Bank; 18-00-02 is Coutts Bank">Sort Code</th>
                    <th>Account Number</th>
                    <th class="bg-warning"><span class="text-primary">Share certificate (Standard)</th>
                    <th class="bg-warning"><span class="text-primary">Share certificate (Enhanced)</th>
                </tr>
                </thead>
                <tbody>
                {% for fundraise in fundraises %}
                    {% if loggedUser.getShareForPub(fundraise.pub) and fundraise.pub.fundRaisePercent >0 %}
                        {% set fundRaiseContribution = fundraise.getContributionForInvestor(shareholder) %}
                        {% set ProRataPrefShares = fundraise.pub.fundRaisePercent * shareholder.getInvestmentAmountForPub(fundraise.pub) %}
                        {% set MaxSuperPrefShares = (fundraise.pub.maxPercentEquityInExcessPrefShares* shareholder.getInvestmentAmountForPub(fundraise.pub)) %}
                        {% if fundRaiseContribution is not null %}
                            {% set EnhancedPrefs = fundRaiseContribution.amount -ProRataPrefShares %}
                            {% set StandardSharesAllocated = min(fundRaiseContribution.amount,ProRataPrefShares) %}
                            {% set EnhancedSharesAllocated = min( (fundRaiseContribution.amount - StandardSharesAllocated), MaxSuperPrefShares) %}
                        {% endif %}
                        <tr>
                            <td style="font: bold"> {{ fundraise.pub.name }}</td>
                            <td style="text-align: center"> {{ fundraise.pub.fundRaisePercent*100 }}%</td>
                            <td style="text-align: center"> {{ fundraise.pub.prefShareInterestRate *100 }} %</td>
                            <td style="text-align: center"> {{ (fundraise.pub.prefShareInterestRate +0.03)*100 }} %</td>
                            <td style="text-align: center"><a target="_blank" class
                                                              href="{{ fundraise.pub.prefShareLink }}">Link</a></td>
                            <td style="text-align: center"><a target="_blank" class
                                                              href="{{ fundraise.pub.prefShareForm }}">Link</a></td>
                            <td> {{ fundraise.pub.bankAccountName }}</td>
                            <td> {{ fundraise.pub.bankSortCode }}</td>
                            <td> {{ fundraise.pub.bankAccountNumber }}</td>
                            <td style="text-align: center">
                                {% if fundRaiseContribution is not null %}
                                <a title="£{{ StandardSharesAllocated |number_format }}; Cert #{{ fundRaiseContribution.shareCertNumberStandard }}"
                                   target="_blank" class
                                   href="{{ path('dashboard_fundraise_sharecert', {'shareholder':shareholder.id, 'pubID': fundraise.pub.id, 'shareclass': '', 'numbershares':StandardSharesAllocated, 'shareCertNumber':fundRaiseContribution.shareCertNumberStandard}) }}"><i
                                            class="fas fa-file-pdf" style="font-size: 20px; color: red"></i></a></td>
                            {% endif %}
                            <td style="text-align: center">
                                {% if EnhancedPrefs >10 and fundRaiseContribution is not null %}
                                <a title="£{{ EnhancedPrefs |number_format }}; Cert #{{ fundRaiseContribution.shareCertNumberEnhanced }}"
                                   target="_blank" class
                                   href="{{ path('dashboard_fundraise_sharecert', {'shareholder':shareholder.id, 'pubID': fundraise.pub.id, 'shareclass': 'Enhanced', 'numbershares':EnhancedSharesAllocated, 'shareCertNumber':fundRaiseContribution.shareCertNumberEnhanced}) }}"><i
                                            class="fas fa-file-pdf" style="font-size: 20px; color: red"></i></a></td>
                            {% endif %}
                            </td>
                        </tr>
                    {% endif %}
                {% else %}
                {% endfor %}
                </tbody>
            </table>
        </div>
    </div>

    <hr>
    <h1 class="text-danger">{{ shareholder.fullname }}: Please specify your Pref Share subscription amount(s):</h1>
    <li>If you would like to change your allocation amount please contact <a target="_blank" class
                                                                             href="mailto:brigitte@trafalgartavern.co.uk">
            <span class="text-warning"> <b>brigitte@trafalgartavern.co.uk</b></span></a>
    </li><br><br>

    <table class="table">
        <thead>
        <tr>
            <th>Pub</th>
            <th>Your Original Investment (£)</th>
            <th>Pref Share "Ask" (£)</th>
            <th>Subscribed Amount (£)</th>

            <th style="text-align: center">Allocated: Standard Prefs (£)</th>
            <th style="text-align: center">Allocated: Super Prefs (£)</th>
            <th style="text-align: center">Monies received</th>
            <th style="text-align: center">Days accrued</th>
            <th style="text-align: center">Standard Prefs Interest (£)</th>
            <th style="text-align: center">Super Prefs Interest (£)</th>


            {% if is_granted ('ROLE_SUPER_ADMIN') %}
                <th> --</th>
                {#                <th style="color: red">Guaranteed allocation to Standard (Pro-rata) Pref Shares (Up to "Ask") (£)</th> #}
                {#                <th style="color: red">Maximum allocation of Super Pref Shares (Final amount TBC) (£)</th> #}
                {#                <th style="color: red">Final total allocation (£)</th> #}
                <th style="color: red">Not subscribing</th>
                <th style="color: red">Subscribe exact</th>
                <th style="color: red">Subscribe bespoke</th>
                <th style="color: red">Monies sent</th>
                <th style="color: red">Monies sent time</th>
                <th style="color: red">Monies rec'd</th>
            {% endif %}
        </tr>


        </thead>
        <tbody>
        {% for fundraise in fundraises %}
            {% if shareholder.getShareForPub(fundraise.pub) and fundraise.pub.fundRaisePercent >0 %}
                {% set fundRaiseContribution = fundraise.getContributionForInvestor(shareholder) %}
                {% set ProRataPrefShares = fundraise.pub.fundRaisePercent * shareholder.getInvestmentAmountForPub(fundraise.pub) %}
                {% set MaxSuperPrefShares = (fundraise.pub.maxPercentEquityInExcessPrefShares* shareholder.getInvestmentAmountForPub(fundraise.pub)) %}

                <tr>
                    <td> {{ fundraise.pub.name }}</td>
                    <td style="text-align: center"> {{ shareholder.getInvestmentAmountForPub(fundraise.pub)|number_format }}  </td>
                    <td style="text-align: center"> {{ (fundraise.pub.fundRaisePercent * shareholder.getInvestmentAmountForPub(fundraise.pub)) | number_format }}  </td>

                    {% if fundRaiseContribution is not null %}
                        <td style="text-align: center"> {{ (fundRaiseContribution.amount is not null) ? fundRaiseContribution.amount |number_format : 'Not subscribing' }} </a></td>

                        {# Allocated Standard Pref #}
                        <td style="text-align: center">
                            {% set StandardPrefsAllocated = min(fundRaiseContribution.amount,ProRataPrefShares) %}
                            {{ (fundRaiseContribution.amount is not null) ? StandardPrefsAllocated|number_format : 'Not subscribing' }}
                        </td>

                        {# Allocated Super Pref #}
                        <td style="text-align: center">
                            {% set SuperPrefsAllocated = max((fundRaiseContribution.amount- ProRataPrefShares),0) %}
                            {{ (fundRaiseContribution.amount is not null) ? SuperPrefsAllocated|number_format : 'Not subscribing' }}
                        </td>

                        {# Monies received #}
                        <td>{% if fundRaiseContribution.paymentSent is not null %}
                                {{ fundRaiseContribution.paymentSent.format('d-M-Y') }}
                            {% endif %}
                        </td>

                        {# Days Accrued #}
                        <td style="text-align: center">
                            {% set differenceActual = date(fundraise.pub.prefShareAccrualEndDate).diff(date(fundRaiseContribution.paymentSent)) %}
                            {% set differenceDefault = date(fundraise.pub.prefShareAccrualEndDate).diff(date(fundraise.pub.prefShareDefaultMoniesReceivedDate)) %}
                            {% set DaysActual = differenceActual.days  %}
                            {% set DaysDefault = differenceDefault.days  %}
                            {% if fundRaiseContribution.amount <1 %}
                                -
                            {% else %}
                                {% if fundRaiseContribution.paymentSent is not null %}
{#                                    <span style="color: gray"> {{ DaysActual }}</span>#}
                                    <span style="color: gray"> {{ DaysDefault }}</span>
                                {% else %}
                                    <span style="color: green"> {{ DaysDefault }}</span>
                                {% endif %}
                            {% endif %}
                        </td>

                        {# Standard Prefs Interest Accured #}
                        <td style="text-align: center">
                            {% if fundRaiseContribution.paymentSent is not null %}
                                <span style="color: gray">
{#                                    {{ (StandardPrefsAllocated * DaysActual * fundraise.pub.prefShareInterestRate /365) |number_format(2, '.', ',') }}#}
                                    {{ (StandardPrefsAllocated * DaysDefault * fundraise.pub.prefShareInterestRate /365) |number_format(2, '.', ',') }}
                                    </span>
                            {% else %}
                                <span style="color: green">
                                {{ (StandardPrefsAllocated * DaysDefault * fundraise.pub.prefShareInterestRate /365) |number_format(2, '.', ',') }}
                            </span>
                            {% endif %}
                        </td>


                        {# Super Prefs Interest Accured #}
                        <td style="text-align: center">
                            {% if fundRaiseContribution.paymentSent is not null %}
                                <span style="color: gray">
{#                                    {{ (SuperPrefsAllocated * DaysActual * (fundraise.pub.prefShareInterestRate+0.03) /365) |number_format(2, '.', ',') }}#}
                                    {{ (SuperPrefsAllocated * DaysDefault * (fundraise.pub.prefShareInterestRate+0.03) /365) |number_format(2, '.', ',') }}
                                    </span>
                            {% else %}
                                <span style="color: green">
                                {{ (SuperPrefsAllocated * DaysDefault * (fundraise.pub.prefShareInterestRate+0.03) /365) |number_format(2, '.', ',') }}
                            </span>
                            {% endif %}
                        </td>

                        {% if is_granted ('ROLE_SUPER_ADMIN') %}
                            <td> >></td>
                            {#                            <td> {{ (fundRaiseContribution.amount is not null) ? min(fundRaiseContribution.amount,ProRataPrefShares)|number_format : 'Not subscribing' }}  </td> #}
                            {#                            <td> {{ (fundRaiseContribution.amount is not null) ? MaxSuperPrefShares |number_format : 'Not subscribing' }}  </td> #}
                            {#                            <td> {{ (fundRaiseContribution.amount is not null) ? min(fundRaiseContribution.amount,(ProRataPrefShares+MaxSuperPrefShares))|number_format : 'Not subscribing' }}  </td> #}
                            <td><a class="btn btn-danger btn-sm"
                                   href="{{ path('dashboard_fundraise_nocontribute', {'id': fundraise.id,'shareholderid':shareholder.id}) }}">Not
                                    Subscribing </a></td>
                            <td><a class="btn btn-info btn-sm"
                                   href="{{ path('dashboard_fundraise_contribute_prorata', {'id': fundraise.id,'shareholderid':shareholder.id}) }}">Subscribe
                                    'Ask'amount exactly</a></td>
                            <td><a class="btn btn-success btn-sm"
                                   href="{{ path('dashboard_fundraise_contribute', {'id': fundraise.id,'shareholderid':shareholder.id}) }}">Subscribe
                                    Bespoke/Additional</a></td>
                            <td><a class="btn btn-info btn-sm"
                                   href="{{ path('dashboard_fundraise_paymentsent', {'id': fundraise.id,'shareholderid':shareholder.id}) }}">Money
                                    sent</a>
                                <a class="btn btn-outline-info btn-sm mt-1"
                                   href="{{ path('dashboard_fundraise_paymentsent', {'id': fundraise.id,'shareholderid':shareholder.id}) }}?Set=false"
                                   onclick="return confirm('Are you sure?')">Clear</a></td>
                            <td>{% if fundRaiseContribution.paymentSent is not null %}
                                    {{ fundRaiseContribution.paymentSent.format('d-M-Y') }}
                                {% endif %}</td>
                            <td> {{ fundRaiseContribution.moniesReceived |number_format }}</td>
                        {% endif %}
                    {% endif %}

                </tr>
            {% endif %}
        {% endfor %}


        </tbody>
    </table>
    <br>
    <div class="row">
        <div class="col-md-9">
        </div>
        <div class="col-md-3">
            {% if is_granted ('ROLE_ADMIN') %}
                Send confirmation Email to shareholder:  <a class="btn btn-outline-info btn-sm"
                                                            href="{{ path('dashboard_user_contact', {'id': shareholder.id }) }}">E-mail
                summary to shareholder</a>
            {% endif %}
        </div>
    </div>
    <hr>


    <h1 class="text-danger">Secondary market</h1>

    <div class="row">
        <div class="col-md-6">
            <ul>
                <li>If you would like to buy or sell your investment in any of the pubs, please indicate using the
                    buttons on the right.
                </li>
                <li>Clicking on the below will simply make your contact details and a willingness to transact visible to
                    the other shareholders.
                </li>
                <li>EIS Tax loss tax offset rule: Losses beyond the first 30% can be claimed against income in the year
                    that the loss is realised, or carried back to the prior year.
                </li>
                <li>The Directors or SAG will not be "making markets", but this site will allow shareholders to contact
                    each other bilaterally.
                </li>
                <li>Please make sure you contact details are up to date as these will be displayed.<br>
                    The website will display:: Email: {{ shareholder.email }}; Phone {{ shareholder.mobile }}</li>
                <li>To update your contact details, click <a target="_blank" title="{{ shareholder.fundraisecomments }}"
                                                             href="{{ path('dashboard_user_edit_my_profile', { 'id': shareholder.id }) }}">here</a>
                </li>
            </ul>
        </div>

        <div class="col-md-6">
            <table class="table">
                <thead>
                <tr>
                    <th>Pub</th>
                    <th>EIS exit date</th>
                    <th>Buyer</th>
                    <th>Seller</th>
                </tr>
                </thead>
                <tbody>
                {% for pub in pubs %}
                    {% if is_granted('ROLE_SUPER_ADMIN')  or is_granted('PUB_ACCESS',pub) %}
                        <tr>
                            <td>
                                {{ pub.name }}
                            </td>
                            <td>
                                <span class="text-{{ (pub.getEndOfEiS() < date()) ? 'success' : 'danger' }}">{{ pub.getEndOfEiS().format('d-M-Y') }}</span>
                            </td>
                            <td>
                                <a class="btn btn-outline-success btn-sm"
                                   href="{{ path('dashboard_secondary_market_sell_or_buy_pub', {'action': 'buy', 'slug': pub.slug, 'decision': 'yes', 'user': shareholder.id}) }}">Yes</a>
                                <a class="btn btn-outline-danger btn-sm"
                                   href="{{ path('dashboard_secondary_market_sell_or_buy_pub', {'action': 'buy', 'slug': pub.slug, 'decision': 'no', 'user': shareholder.id}) }}">No</a>
                                {% if shareholder.getSecondaryMarketForPub(pub) is not null and shareholder.getSecondaryMarketForPub(pub).buy is not null %}
                                    {% set secondaryMarket = shareholder.getSecondaryMarketForPub(pub) %}
                                    {{ (secondaryMarket.buy) ? 'Yes' : 'No' }}
                                {% endif %}
                            </td>
                            <td>
                                <a class="btn btn-outline-success btn-sm"
                                   href="{{ path('dashboard_secondary_market_sell_or_buy_pub', {'action': 'sell', 'slug': pub.slug, 'decision': 'yes', 'user': shareholder.id}) }}">Yes</a>
                                <a class="btn btn-outline-danger btn-sm"
                                   href="{{ path('dashboard_secondary_market_sell_or_buy_pub', {'action': 'sell', 'slug': pub.slug, 'decision': 'no', 'user': shareholder.id}) }}">No</a>
                                {% if shareholder.getSecondaryMarketForPub(pub) is not null and shareholder.getSecondaryMarketForPub(pub).sell is not null %}
                                    {% set secondaryMarket = shareholder.getSecondaryMarketForPub(pub) %}
                                    {{ (secondaryMarket.sell == 1) ? 'Yes' : 'No' }}
                                {% endif %}
                            </td>
                        </tr>
                    {% endif %}
                {% endfor %}

                </tbody>
            </table>
        </div>
    </div>
    </div>
    <br><br>
    <hr>

{% endblock %}
{% block datatable %}
    <script>
        $(document).ready(function () {
            $('.table').DataTable({
                'pageLength': 10,
                "paging": false,
                "searching": false,
                "bInfo": false,
                "order": [[0, 'asc']]
            });
        });
    </script>
{% endblock datatable %}