{% extends 'base_admin.html.twig' %}
{% block title %}Pref Share raise - {{ fundraise.pub.name }} {% endblock %}
{% block body %}
    <h1 class="text-danger">{{ fundraise.pub.name }} </h1>
    <h4 style="color: blue;"><b>Note: This page is only viewable by SAG.</b></h4>
    <hr>
    <div class="row">
        <div class="col-md-3">
            <ul>
                <h2 style="color: red">Total raised</h2>
                <li>
                    <span class="font-weight-bold">Total contributions (pre-cap): </span>£{{ total|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Total contributions (post-cap): </span>£{{ cappedtotal |number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Still to raise (full): </span>£{{ max(0,((pub.totalShares *pub.fundRaisePercent) - (cappedtotal)))|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Still to raise (exc D/JM fees): </span>£{{ max(0, ((pub.totalShares *pub.fundRaisePercent)- (pub.ducalianAndHarcourtInnsFees)- (cappedtotal)))|number_format }}
                </li>
                <li>
                    <span class="text-danger">Fund Raise Completion (Full/Lower) (pre-cap): </span>
                    {% if pub.fundRaisePercent >0 %}
                        {{ (total/ (pub.totalShares *pub.fundRaisePercent) *100)|number_format }}%
                        /{{ (total/ ((pub.totalShares *pub.fundRaisePercent)- (pub.ducalianAndHarcourtInnsFees)) *100)|number_format }}
                    {% endif %}
                    % <br>
                </li>
                <br>

                <li>
                    <span class="font-weight-bold">Elections received (Share equity):</span>£{{ PubService.pubGetElectionsReceived(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Shareholder response rate (% of equity): </span>{{ ((100*PubService.pubGetElectionsReceived(fundraise.pub))/pub.totalShares) |number_format }}
                    % <br>
                </li>
                <li>
                    {% if pub.fundRaisePercent >0 %}
                        <span class="font-weight-bold">Shareholder participation: </span> {{ ( ((100*total)/ (pub.totalShares *pub.fundRaisePercent)) /
                    (PubService.pubGetElectionsReceived(fundraise.pub)/pub.totalShares) )|number_format }}%
                    {% endif %}
                </li>
                <br>
                <li>
                    <span class="font-weight-bold">Pro-rata contributions:</span>£{{ PubService.pubGetAskOffered(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Pro-rata shortfalls: </span>£{{ PubService.pubGetShortfall(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Excess contributions offered (pre-cap):</span>£{{ PubService.pubGetExcess(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Excess contributions offered (capped):</span>£{{ PubService.pubGetCappedExcess(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Non-subscribing investors: </span>£ {{ PubService.pubGetNonSubscribe(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Net Excess/Shortfall: </span>£ {{ (PubService.pubGetExcess(fundraise.pub) - PubService.pubGetNonSubscribe(fundraise.pub))|number_format }}
                </li>
                <br>

            </ul>
        </div>

        <div class="col-md-3">
            <ul>
                <h2 style="color: red">Overall economics</h2>
                <li>
                    <span class="font-weight-bold">Initial Equity:</span> £{{ pub.totalShares |number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Fund Raise (% of Initial Investment):</span> {{ pub.fundRaisePercent * 100 }}
                    %
                </li>
                <li>
                    <span class="font-weight-bold">Target Fund Raise:</span>
                    £{{ (pub.totalShares *pub.fundRaisePercent) | number_format }}
                </li>

                <li>
                    <span class="font-weight-bold">Lower band fund raise:</span> {{ ((pub.totalShares *pub.fundRaisePercent) -(pub.ducalianAndHarcourtInnsFees) ) | number_format }}
                </li>
                <br>
                <li>
                    <span class="font-weight-bold">Pref Share Interest Rate (Pro-Rata):</span> {{ pub.prefShareInterestRate *100 }}
                    %
                </li>
                <li>
                    <span class="font-weight-bold">Pref Share Interest Rate (Additional):</span> {{ (pub.prefShareInterestRate +0.03) *100 }}
                    %
                </li>
                <li>
                    <span class="font-weight-bold">Shareholder letter:</span> <a target="_blank"
                                                                                 href="{{ pub.prefShareLink }}">Link</a>
                </li>

            </ul>
        </div>
        <div class="col-md-3">
            <ul>
                <h2 style="color: red">Caps</h2>
                <li>
                    <span class="font-weight-bold">Cap on total contribution (% Original Equity):</span> <a
                            target="_blank" class
                            href="{{ path('dashboard_pub_edit', {'slug': pub.slug}) }}">{{ pub.maxPercentEquityInExcessPrefShares *100 }}
                        %</a>
                </li>
                <li>
                    <span class="font-weight-bold">Total excess contributions offered:</span>£{{ PubService.pubGetExcess(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Required Excess to be funded:</span>£ {{ ( (pub.totalShares*pub.fundRaisePercent) - PubService.pubGetAskOffered(fundraise.pub) )|number_format }}
                </li>
                <br>
                {#                <h2>Proxy vote</h2> #}
                {#                <li> #}
                {#                    <span class="font-weight-bold">Proxy Yes:</span> £ {{ PubService.pubGetProxyYes(fundraise.pub)|number_format }} #}
                {#                </li> #}
                {#                <li> #}
                {#                    <span class="font-weight-bold">Proxy No:</span> £ {{ PubService.pubGetProxyNo(fundraise.pub)|number_format }} #}
                {#                </li> #}
                {#                <li> #}
                {#                    <span class="font-weight-bold">Yes Vote:</span>  {{ ((100*PubService.pubGetProxyYes(fundraise.pub))/(PubService.pubGetProxyYes(fundraise.pub) + PubService.pubGetProxyNo(fundraise.pub)  )) |number_format }}% #}
                {#                </li> #}
                {#                <li> #}
                {#                    <span class="font-weight-bold">Shareholders voted:</span>  {{ ((100*(PubService.pubGetProxyYes(fundraise.pub) + PubService.pubGetProxyNo(fundraise.pub))) / pub.totalShares)|number_format }}% #}
                {#                </li> #}
                <h2 style="color: red">Monies received</h2>
                <li>
                    <span class="font-weight-bold">Standard Prefs:</span>
                    £ {{ PubService.pubGetMoniesRaisedStandard(fundraise.pub)|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Enhanced Prefs:</span>
                    £ {{ (PubService.pubGetMoniesRaisedTotal(fundraise.pub)- PubService.pubGetMoniesRaisedStandard(fundraise.pub))|number_format }}
                </li>
                <li>
                    <span class="font-weight-bold">Total:</span>
                    £ {{ PubService.pubGetMoniesRaisedTotal(fundraise.pub)|number_format }}
                </li>
                <br>

                <h2 style="color: red">Daily accrual; Total (default accrual)</h2>
                {% set differenceDefaultX = date(fundraise.pub.prefShareAccrualEndDate).diff(date(fundraise.pub.prefShareDefaultMoniesReceivedDate)) %}
                {% set DaysDefaultX = differenceDefaultX.days  %}

                <li>
                    <span class="font-weight-bold">Standard Prefs:</span>
                    {% set StandardPrefDailyAccrualAllInvestors =  (PubService.pubGetAskOffered(fundraise.pub) * pub.prefShareInterestRate /365)  %}

                    £ {{ StandardPrefDailyAccrualAllInvestors|number_format(2, '.', ',') }} ; Total: £ {{ (DaysDefaultX*StandardPrefDailyAccrualAllInvestors)|number_format(2, '.', ',') }}
                </li>
                <li>
                    <span class="font-weight-bold">Enhanced Prefs:</span>
                    {% set SuperPrefDailyAccrualAllInvestors =
                        (PubService.pubGetMoniesRaisedTotal(fundraise.pub)- PubService.pubGetMoniesRaisedStandard(fundraise.pub)) * (pub.prefShareInterestRate+0.03) /365 %}
                    £ {{ SuperPrefDailyAccrualAllInvestors|number_format(2, '.', ',') }} ; Total: £{{ (DaysDefaultX* SuperPrefDailyAccrualAllInvestors)|number_format(2, '.', ',') }}
                </li>
                <li>
                    <span class="font-weight-bold">Total:</span>
                    £ {{ (StandardPrefDailyAccrualAllInvestors + SuperPrefDailyAccrualAllInvestors)|number_format(2, '.', ',') }} ;
                    Total: £ {{ (DaysDefaultX*(StandardPrefDailyAccrualAllInvestors + SuperPrefDailyAccrualAllInvestors))|number_format(2, '.', ',') }}
                </li>

            </ul>
        </div>

    </div>
    {% if is_granted ('ROLE_ADMIN') %}
        <table class="table">
            <thead>
            <tr>
                <th>Cert # (Standard)</th>
                <th>Cert # (Enhanced)</th>
                <th>Investor</th>
                <th>Email<span style="color:red"> Hover to show</span></th>
                <th>Phone <span style="color:red">  Click to edit/add </span></th>
                <th>SAG</th>
                <th>Referer</th>
                <th>Investment</th>
                <th>Ask</th>
                <th>Contribution</th>
                {% if is_granted('ROLE_ADMIN') %}
                    <th style="color: red">Edit election</th>
                    {#                <th>|</th> #}
                    {#                <th>Allocated Standard Prefs</th> #}
                    {#                <th>Super Prefs requested</th> #}
                    {#                <th>Cap on Super Prefs (SA)</th> #}
                    <th style="color: red">#</th>
                    {#                <th style="color: red; text-align: right"> Final Allocation (Pro-rata Prefs + Capped Super Prefs)</th> #}
                    <th style="color: red; text-align: right"> Standard Prefs Allocated</th>
                    <th style="color: red; text-align: right"> Super Prefs Allocated</th>
                    <th style="color: red; text-align: right"> Date money sent</th>
                    <th style="color: red; text-align: right"> Money received?</th>
                    <th style="color: red; text-align: right"> Days accrued.
                        <span style="color: green">Default =
                        {% set difference = date(fundraise.pub.prefShareAccrualEndDate).diff(date(fundraise.pub.prefShareDefaultMoniesReceivedDate)) %}
                            {% set leftDaysDefault = difference.days+1 %}
                            {{ leftDaysDefault }} days
                        </span>
                    </th>
                    <th style="color: red; text-align: right"> Standard prefs Interest</th>
                    <th style="color: red; text-align: right"> Super prefs Interest</th>
                {% endif %}
            </tr>

            </thead>
            <tbody>
            {% if AllOrAwaiting=='all' %}
                {% set flag= 100000000000 %}
            {% else %}
                {% set flag=1 %}
            {% endif %}
            {% set continue=false %}
            {% set TotalStandardPrefShares=0 %}
            {% set TotalSuperPrefShares=0 %}
            {% set TotalStandardPrefSharesInterestDefault=0 %}
            {% set TotalStandardPrefSharesInterestActual=0 %}
            {% set TotalSuperPrefSharesInterestDefault=0 %}
            {% set TotalSuperPrefSharesInterestActual=0 %}


            {% for contribution in fundraise.fundRaiseContributions %}

                {% if contribution.moniesReceived < flag %}
                    {% set ask = fundraise.pub.fundRaisePercent * contribution.shareholder.getInvestmentAmountForPub(fundraise.pub) %}
                    {% set standardPrefSharesAllocated = min(contribution.amount,ask) %}
                    {% set superPrefSharesRequested = max(contribution.amount-ask,0) %}
                    {% set maxSuperPrefSharesAllocated = (pub.maxPercentEquityInExcessPrefShares*contribution.shareholder.getInvestmentAmountForPub(fundraise.pub)) %}
                    {% set totalAllocatedAmount =  ((standardPrefSharesAllocated + min(maxSuperPrefSharesAllocated,superPrefSharesRequested)) ) %}
                    {% set superPrefSharesAllocated = ( totalAllocatedAmount -standardPrefSharesAllocated) %}

                    <tr class="{{ (contribution.shareholder.isToVerifyEmail) ? 'table-danger' : '' }}">
                        <td>
                            <a href="{{ path('dashboard_fundraise_contribute', {'id': fundraise.id,'shareholderid':contribution.shareholder.id}) }}">{{ contribution.shareCertNumberStandard }}
                                ..</a>
                            {#             {% if (contribution.amount >1) %} #}
                            {#                  <a target="_blank" class="btn btn-outline-danger" #}
                            {#                               href="{{ path('dashboard_fundraise_sharecert', {'shareholder':contribution.shareholder.id, 'pubID': fundraise.pub.id, 'shareclass': 'Standard', 'numbershares':StandardSharesAllocated}) }}"><i #}
                            {#                                        class="fas fa-file-pdf" style="font-size: 10px; color: red"></i></a></td> #}
                            {#                        {% endif %} #}
                        </td>
                        <td>
                            <a href="{{ path('dashboard_fundraise_contribute', {'id': fundraise.id,'shareholderid':contribution.shareholder.id}) }}">{{ contribution.shareCertNumberEnhanced }}
                                ..</a></td>
                        <td title="{{ contribution.shareholder.email }}"><a target="_blank"
                                                                            href="{{ path('dashboard_user_edit', {'id': contribution.shareholder.id}) }}">{{ contribution.shareholder.fullname }}  {{ contribution.shareholder.wealthclub? '(WC)': '' }}</a>
                        </td>
                        <td title="{{ contribution.shareholder.email }}"
                        "><a target="_blank"
                             href="{{ path('dashboard_user_contact', {'id': contribution.shareholder.id }) }}">email</a>
                        <td title="{{ contribution.shareholder.email }}"><a target="_blank"
                                                                            href="{{ path('dashboard_user_edit', {'id': contribution.shareholder.id}) }}">
                                {% if contribution.shareholder.mobile is not null %}  {{ contribution.shareholder.mobile }} {% else %} Add{% endif %}</a>
                        </td>
                        <td>{{ (contribution.shareholder.isSagMember) ? 'Yes' : 'No' }}</td>
                        <td>{{ contribution.shareholder.referal }}</td>
                        <td>{{ contribution.shareholder.getInvestmentAmountForPub( fundraise.pub)|number_format }}</td>
                        <td>{{ ask |number_format }}</td>
                        <td data-sort="{{ contribution.amount }}"><a target="_blank"
                                                                     href="">{{ (contribution.amount is null) ? 'NS' : contribution.amount|number_format }}</a>
                        </td>
                        {% if is_granted('ROLE_ADMIN') %}
                            <td>
                                <a target="_blank" class="btn btn-outline-info btn-sm"
                                   href="{{ path('dashboard_fundraise_index', {'shareholder': contribution.shareholder.id}) }}">Election
                            </td>
                            {#                        <td> |</td> #}
                            {#                        <td> {{ standardPrefSharesAllocated |number_format }}</td> #}
                            {#                        <td> {{ max(contribution.amount-ask,0)|number_format }}</td> #}
                            {#                        <td> {{ maxSuperPrefSharesAllocated|number_format }} </td> #}
                            <td>
                                <a class="btn btn-success btn-sm mt-1"
                                   href="{{ path('dashboard_fundraise_monies_received', {'id': fundraise.id,'shareholderid':contribution.shareholder.id, 'allocatedamount':totalAllocatedAmount, 'AllOrAwaiting': 'all'}) }}">Money
                                    rec'd</a>
                                <a class="btn btn-outline-info btn-sm mt-1"
                                   href="{{ path('dashboard_fundraise_contribute', {'id': fundraise.id,'shareholderid':contribution.shareholder.id}) }}?return=true ">Money
                                    rec'd (bespoke)</a>
                                <a class="btn btn-outline-danger btn-sm mt-1" target="_blank"
                                   href="{{ path('dashboard_user_contact', {'id': contribution.shareholder.id }) }}">Acknowledge
                                    & thanks</>
                            </td>
                            {#                            <td style="text-align: right"> {{ totalAllocatedAmount|number_format }}</td> #}
                            <td style="text-align: right">
                                {{ standardPrefSharesAllocated |number_format }}
                            </td>
                            <td style="text-align: right">
                                {{ superPrefSharesAllocated |number_format }}
                            </td>
                            <td style="text-align: right">
                                {% if contribution.paymentSent is not null %}
                                    {{ contribution.paymentSent.format('d-M-Y') }}
                                {% endif %}</td>
                            <td style="text-align: right">
                                {{ contribution.moniesReceived |number_format }}
                            </td>

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

                            <td style="text-align: right"
                            {% if contribution.paymentSent is not null %}
                                <span style="color: gray">
                                    {{ ((standardPrefSharesAllocated * DaysActual * pub.prefShareInterestRate /365)) |number_format(2, '.', ',') }} |
                                    </span>
                            {% endif %}
                            <span style="color: green">
                                {{ (standardPrefSharesAllocated * DaysDefault * pub.prefShareInterestRate /365) |number_format(2, '.', ',') }}
                            </span>
                            {% set TotalStandardPrefSharesInterestDefault = TotalStandardPrefSharesInterestDefault +
                                (standardPrefSharesAllocated * DaysDefault * pub.prefShareInterestRate /365) %}
                            {% set TotalStandardPrefSharesInterestActual = TotalStandardPrefSharesInterestActual +
                                (standardPrefSharesAllocated * max(DaysDefault,DaysActual) * pub.prefShareInterestRate /365) %}
                            {% set TotalStandardPrefShares  = TotalStandardPrefShares + standardPrefSharesAllocated %}
                            </td>
                            <td style="text-align: right"
                            {% if contribution.paymentSent is not null %}
                                <span style="color: blue">
                                    {{ (superPrefSharesAllocated * DaysActual * (pub.prefShareInterestRate+0.03) /365) |number_format(2, '.', ',') }} |
                                    </span>
                            {% endif %}
                            <span style="color: green">
                                {{ (superPrefSharesAllocated * DaysDefault * (pub.prefShareInterestRate +0.03) /365) |number_format(2, '.', ',') }}
                            </span>

                            {% set TotalSuperPrefSharesInterestDefault = TotalSuperPrefSharesInterestDefault +
                                (superPrefSharesAllocated * DaysDefault * (pub.prefShareInterestRate+0.03) /365) %}
                            {% set TotalSuperPrefSharesInterestActual = TotalSuperPrefSharesInterestActual +
                                (superPrefSharesAllocated * max(DaysDefault,DaysActual) * (pub.prefShareInterestRate+0.03) /365) %}
                            {% set TotalSuperPrefShares  = TotalSuperPrefShares + superPrefSharesAllocated %}
                            </td>
                        {% endif %}
                    </tr>
                {% endif %}
            {% endfor %}
            </tbody>
        </table>
    {% endif %}

    <br>
    <hr>

    <div class="row">
        <div class="col-1"></div>
        <div class="col-3">
            <h3 style="color: red">Total Pref Shares</h3>
            <li>
                <b>Standard Pref Shares
                    Interest:</b> {{ TotalStandardPrefShares|number_format(2, '.', ',') }}
            </li>

            <li>
                <b>Super Pref Shares Interest:</b> {{ TotalSuperPrefShares|number_format(2, '.', ',') }}
            </li>
            <li>
                <b>Total Pref Shares Interest:</b> {{ (TotalStandardPrefShares+TotalSuperPrefShares)|number_format(2, '.', ',') }}
            </li>

        </div>


        <div class="col-3">
            <h3 style="color: red">Total Interest: Default Accrual Start</h3>
            <li>
                <b>Standard Pref Shares
                    Interest:</b> {{ TotalStandardPrefSharesInterestDefault|number_format(2, '.', ',') }}
            </li>

            <li>
                <b>Super Pref Shares Interest:</b> {{ TotalSuperPrefSharesInterestDefault|number_format(2, '.', ',') }}
            </li>
            <li>
                <b>Total:</b> {{ (TotalStandardPrefSharesInterestDefault + TotalSuperPrefSharesInterestDefault )|number_format(2, '.', ',') }}
            </li>
        </div>
        <div class="col-3">
            <h3 style="color: red">Total Interest: Actual Accrual Start</h3>
            <li>
                <b>Standard Pref Shares
                    Interest:</b> {{ TotalStandardPrefSharesInterestActual|number_format(2, '.', ',') }}
            </li>
            <li>
                <b>Super Pref Shares Interest:</b> {{ TotalSuperPrefSharesInterestActual|number_format(2, '.', ',') }}
            </li>
            <li>
                <b>Total:</b> {{ (TotalStandardPrefSharesInterestActual + TotalSuperPrefSharesInterestActual )|number_format(2, '.', ',') }}
            </li>
        </div>

        <br>
        <hr>

    </div>

    <br>
    <hr>
    <br>
{% endblock %}

{% block datatable %}
    <script>
        $(document).ready(function () {
            $('.table').DataTable({
                'pageLength': 100,
                "order": [[12, 'desc']]
            });
        });
    </script>
{% endblock datatable %}