{% extends 'base_admin.html.twig' %}
{% block title %}Fund Raise - {{ shareholder.fullname }} {% endblock %}
{% block body %}
    <div class="row">
        <div class="col-md-4">
            <h1>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>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> {{ fundraise.pub.name }}</td>
                            <td> {{ fundraise.pub.fundRaisePercent*100 }}%</td>
                            <td> {{ fundraise.pub.prefShareInterestRate *100 }} %</td>
                            <td> {{ (fundraise.pub.prefShareInterestRate +0.03)*100 }} %</td>
                            <td><a target="_blank" class href="{{ fundraise.pub.prefShareLink }}">Link</a></td>
                            <td><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>
                                {% if (fundRaiseContribution.amount >1) %}
                                <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>
                            {% if (EnhancedPrefs >10) %}
                                <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>

            {% if is_granted ('ROLE_SUPER_ADMIN') %}
                <th>Break-out >></th>
                <th>Guaranteed allocation to Standard (Pro-rata) Pref Shares (Up to "Ask") (£)</th>
                <th>Maximum allocation of Super Pref Shares (Final amount TBC) (£)</th>
                <th><span style="color:red"> Final total allocation (£)</span></th>
                <th>Not subscribing</th>
                <th>Subscribe exact</th>
                <th>Subscribe bespoke</th>
                <th>Monies sent</th>
                <th>Monies sent time</th>
                <th>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> {{ shareholder.getInvestmentAmountForPub(fundraise.pub)|number_format }}  </td>
            <td> {{ (fundraise.pub.fundRaisePercent * shareholder.getInvestmentAmountForPub(fundraise.pub)) | number_format }}  </td>

            {% if fundRaiseContribution is not null %}
                <td> {{ (fundRaiseContribution.amount is not null) ? fundRaiseContribution.amount |number_format : 'Not subscribing' }} </a></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 g:i') }}
                        {% 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 %}
                    <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>
                {% 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 %}