{% extends 'base_admin.html.twig' %}
{% block title %}Fund raise - {{ fundraise.pub.name }} {% endblock %}
{% block body %}
    <h1 class="text-danger">{{ fundraise.pub.name }} ({{ AllOrAwaiting }})</h1>
    <h4><b>Note: This page is only viewable by SAG.</b></h4>
    <hr>
    <div class="row">
        <div class="col-md-4">
            <ul>
                <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>
                    {{ (total/ (pub.totalShares *pub.fundRaisePercent) *100)|number_format }}%
                    /{{ (total/ ((pub.totalShares *pub.fundRaisePercent)- (pub.ducalianAndHarcourtInnsFees)) *100)|number_format }}
                    % <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>
                    <span class="font-weight-bold">Shareholder participation: </span> {{ ( ((100*total)/ (pub.totalShares *pub.fundRaisePercent)) /
                    (PubService.pubGetElectionsReceived(fundraise.pub)/pub.totalShares) )|number_format }}%
                </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-4">
            <ul>
                <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">Ducalian & Harcout Inns fees:</span> {{ pub.ducalianAndHarcourtInnsFees |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-4">
            <ul>
                <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>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>

            </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>
                <th>Edit election</th>
                <th>|</th>
                <th>Allocated Standard Prefs</th>
                <th>Super Prefs requested</th>
                {% if is_granted('ROLE_SUPER_ADMIN') %}
                    <th>Cap on Super Prefs (SA)</th>
                {% endif %}
                {% if is_granted('ROLE_ADMIN') %}
                    <th>#</th>
                    <th><span style="color:red"> Final Allocation (Pro-rata Prefs + Capped Super Prefs) </span></th>
                    <th>Monies sent</th>
                    <th>Monies received</th>
                {% endif %}
            </tr>
            </thead>
            <tbody>
            {% if AllOrAwaiting=='all' %}
                {% set flag= 100000000000 %}
            {% else %}
                {% set flag=1 %}
            {% endif %}
            {% set continue=false %}
            {% 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)) ) %}










                    <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>
                        <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>
                        {% if is_granted('ROLE_SUPER_ADMIN') %}
                            <td> {{ maxSuperPrefSharesAllocated|number_format }} </td>
                        {% endif %}
                        {% if is_granted('ROLE_ADMIN') %}
                            <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> {{ totalAllocatedAmount|number_format }}</td>
                            <td>
                                {% if contribution.paymentSent is not null %}
                                    {{ contribution.paymentSent.format('d-M-Y g:i') }}
                                {% endif %}</td>
                            <td> {{ contribution.moniesReceived |number_format }}</td>
                        {% endif %}
                    </tr>
                {% endif %}
            {% endfor %}
            </tbody>
        </table>
    {% endif %}
{% endblock %}



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