@include('emails.client_contact.common-finance.header', ['franchise' => $franchise])

@component('emails.common.table', ['wordWrap' => true])
    <tr>
        @component('emails.common.td')

            @component('emails.common.p')
            Hello {{ $userName }},
            @endcomponent

            @component('emails.common.p')
            It's been quite a month, let’s see what we have achieved!
            @endcomponent

            <p></p>

            <p><b>Projects</b></p>

            @if(count($ongoingProjects) > 0)
            <!-- start:: Ongoing Projects -->
            <table style="width: 100%;">
                <tr>
                    <td colspan="4">
                        <span>Ongoing Projects</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Client</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Deadline</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Task Completion Rate</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Budget</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Income</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Expenses</th>
                </tr>
                @foreach ($ongoingProjects as $project)
                    <tr>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->name }}</td>
                        @if(count($project->contacts) > 0)
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $project->contact_companies_formatted }}</td>
                        @else
                            <td style="border:1px solid black; padding: 4px 8px;">Internal</td>
                        @endif
                        <td style="border:1px solid black; padding: 4px 8px;">{{ date(config('custom.formats.sort_date'), strtotime($project->completion_date)) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ ($project->task_completion_rate) ? $project->task_completion_rate . '%' : '-' }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->expected_budget, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->income, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->expenses, 2) }}</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: Ongoing Projects -->
            @endif

            @if(count($pipelineProjects) > 0)
            <!-- start:: Pipeline Projects -->
            <table style="width: 100%; margin-top: 25px !important;">
                <tr>
                    <td colspan="4">
                        <span>Pipeline Projects</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Dept</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Client</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Deadline</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Task Completion Rate</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Expected Budget</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Expected Revenue</th>
                </tr>
                @foreach ($pipelineProjects as $project)
                    <tr>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->name }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->departments_formatted }}</td>
                        @if(count($project->contacts) > 0)
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $project->contact_companies_formatted }}</td>
                        @else
                            <td style="border:1px solid black; padding: 4px 8px;">Internal</td>
                        @endif
                        <td style="border:1px solid black; padding: 4px 8px;">{{ date(config('custom.formats.sort_date'), strtotime($project->completion_date)) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ ($project->task_completion_rate) ? $project->task_completion_rate . '%' : '-' }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->expected_budget, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->expected_revenue, 2) }}</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: Pipeline Projects -->
            @endif

            @if(count($closedProjects) > 0)
            <!-- start:: Closed Projects -->
            <table style="width: 100%; margin-top: 25px !important;">
                <tr>
                    <td colspan="4">
                        <span>Closed Projects</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Client</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Budget</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Income</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Expenses</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">OAS</th>
                </tr>
                @foreach ($closedProjects as $project)
                    <tr>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->name }}</td>
                        @if(count($project->contacts) > 0)
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $project->contact_companies_formatted }}</td>
                        @else
                            <td style="border:1px solid black; padding: 4px 8px;">Internal</td>
                        @endif
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->expected_budget, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->income, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($project->expenses, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->oas }}</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: Closed Projects -->
            @endif

            @if(count($cancelledProjects) > 0)
            <!-- start:: Cancelled/On Hold Projects -->
            <table style="width: 100%; margin-top: 25px !important;">
                <tr>
                    <td colspan="2">
                        <span>Cancelled/On Hold Projects</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Client</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Status</th>
                </tr>
                @foreach ($cancelledProjects as $project)
                    <tr>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->name }}</td>
                        @if(count($project->contacts) > 0)
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $project->contact_companies_formatted }}</td>
                        @else
                            <td style="border:1px solid black; padding: 4px 8px;">Internal</td>
                        @endif
                        <td style="border:1px solid black; padding: 4px 8px;">{{ ucwords(str_replace('_', ' ', $project->status)) }}</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: Cancelled/On Hold Projects -->
            @endif

            <!-- start:: Performance -->
            <table style="width: 100%; margin-top: 25px !important;">
                <tr>
                    <td colspan="3">
                        <span>Performance</span><br/>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;" colspan="2">Overall Individual OAS for this month</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;" colspan="2">{{ $individualOAS }}/{{ $avgOAS }}</th>
                </tr>
                <tr>
                    <td style="border:1px solid black; padding: 4px 8px;">Client Feedback</td>
                    <td style="border:1px solid black; padding: 4px 8px;">Implementation Feedback</td>
                    <td style="border:1px solid black; padding: 4px 8px;">Leadership Feedback</td>
                    <td style="border:1px solid black; padding: 4px 8px;">Task Feedback</td>
                </tr>
                <tr>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ ($clientFeedbackOAS && $clientFeedbackOAS > 0) ? number_format($clientFeedbackOAS, 2) : '-' }}</td>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ ($implementationFeedbackOAS && $implementationFeedbackOAS > 0) ? number_format($implementationFeedbackOAS, 2) : '-' }}</td>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ ($leadershipFeedbackOAS && $leadershipFeedbackOAS > 0) ? number_format($leadershipFeedbackOAS, 2) : '-' }}</td>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ ($taskFeedbackOAS && $taskFeedbackOAS > 0) ? number_format($taskFeedbackOAS, 2) : '-' }}</td>
                </tr>
            </table>
            <!-- end:: Performance -->

            <!-- start:: Pesa -->
            <table style="width: 100%; margin-top: 25px !important;">
                <tr>
                    <td colspan="3">
                        <span>Pesa</span><br/>
                    </td>
                </tr>
                <tr>
                    <td style="border:1px solid black; padding: 4px 8px;">Total Revenue Generated</td>
                    <td style="border:1px solid black; padding: 4px 8px;">Pipeline Revenue</td>
                    <td style="border:1px solid black; padding: 4px 8px;">Total Commission Earned</td>
                    <td style="border:1px solid black; padding: 4px 8px;">Total Commission Paid</td>
                </tr>
                <tr>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($totalRevenueGenerated, 2) }}</td>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($totalPipelineRevenue, 2) }}</td>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($totalCommissionPaid, 2) }}</td>
                    <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($totalCommissionEarned, 2) }}</td>
                </tr>
            </table>
            <!-- end:: Performance -->


            @component('emails.common.p')
            <a href="{{ $url }}" target="_blank">Click here</a> to view more information.
            @endcomponent

            @component('emails.common.slogan')
            @endcomponent

        @endcomponent
    </tr>
    <tr>
        @component('emails.common.td')
            @component('emails.common.p')
                @if($franchise) {{ $franchise->company_name }}@endif Project
            @endcomponent
        @endcomponent
    </tr>
@endcomponent

@include('emails.client_contact.common-finance.footer', ['franchise' => $franchise])