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

@component('emails.common.table')

    <tr>
        @component('emails.common.td')

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

            @component('emails.common.p')
            Please see below your weekly summary on projects:
            @endcomponent

            @component('emails.common.p')
            <span><b>Performance</b></span><br/>
            <span>Task Completed: {{ count($completedTasks) }}/{{ $assignedTasks }}</span><br/>
            <span>Task Assigned: {{ $assignedTasks }}/{{ $involvedTasks }} (Assigned vs Involved)</span><br/>
            <span>Task Completion Rate: @if(!$assignedTasks) 0% @else{{ (count($completedTasks) / $assignedTasks) * 100 }}% @endif</span>
            @endcomponent

            <p></p>

            <!-- start:: completed projects -->
            @if(count($completedTasks) > 0)
                <table style="width: 100%; word-wrap: break-word;">
                    <tr>
                        <td>
                            <span><b>Projects</b></span><br/>
                            <span>Completed Tasks</span>
                        </td>
                    </tr>
                    <tr>
                        <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Task Name</th>
                        <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Name</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;">Rating</th>
                    </tr>
                    @foreach($completedTasks as $task)
                        <tr>
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $task->task_name }}</td>
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $task->project_name }}</td>
                            <td style="border:1px solid black; padding: 4px 8px;">{{ date(config('custom.formats.mail_date_time'), strtotime($task->end_date_time)) }}</td>
                            <td style="border:1px solid black; padding: 4px 8px;">{{ $task->rating }}</td>
                        </tr>
                    @endforeach
                </table>
            @endif
            <!-- end:: completed projects -->

            @if(count($closedProjects) > 0)
            <!-- start:: closed projects -->
            <table style="width: 100%; margin-top: 15px !important; word-wrap: break-word;">
                <tr>
                    <td>
                        <span>Closed Projects</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Name</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Owner</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Duration</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>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->projectOwner[0]->full_name ?? '' }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ Carbon\Carbon::parse($project->published_date)->diffInDays($project->closureDetails->close_date) }} Days</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->project_oas }}</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: closed projects -->
            @endif

            @if(count($pipelineProjects) > 0)
            <!-- start:: pipeline projects -->
            <table style="width: 100%; margin-top: 25px !important; word-wrap: break-word;">
                <tr>
                    <td colspan="4">
                        <span><b>Pipeline</b></span><br/>
                        <span>Projects in Pipeline</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Name</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Owner</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>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Actualization</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->projectOwner[0]->full_name ?? '' }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ number_format($project->expected_budget, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ number_format($project->expected_revenue, 2) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $project->project_actualization }}%</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: pipeline projects -->
            @endif

            <!-- start:: this week meetings -->
            @component('project::emails.common.meetings_table', ['title' => 'This week meetings', 'meetings' => $completedMeetings])
            @endcomponent
            <!-- end:: this week meetings -->

            <!-- start:: upcoming week meetings -->
            @component('project::emails.common.meetings_table', ['title' => 'Upcoming week meetings', 'meetings' => $upcomingMeetings])
            @endcomponent
            <!-- end:: upcoming week meetings -->

            @if(count($pendingBudgetRequests))
            <!-- start:: pending budget requests -->
            <table style="width: 100%; margin-top: 25px !important; word-wrap: break-word;">
                <tr>
                    <td colspan="4">
                        <span><b>Pesa</b></span><br/>
                        <span>Pending Budget requests</span>
                    </td>
                </tr>
                <tr>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Budget Request Title</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Project Name</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Budget Type</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Fulfill by Date</th>
                    <th style="font-weight: normal; border:1px solid black; padding: 4px 8px;">Total Amount</th>
                </tr>
                @foreach($pendingBudgetRequests as $budgetRequest)
                    <tr>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $budgetRequest->title }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $budgetRequest->project_name }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ ucwords(str_replace('_', ' ', $budgetRequest->budget_type)) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ date(config('custom.formats.sort_date'), strtotime($budgetRequest->due_date)) }}</td>
                        <td style="border:1px solid black; padding: 4px 8px;">{{ $franchiseCurrency }} {{ number_format($budgetRequest->total_amount, 2) }}</td>
                    </tr>
                @endforeach
            </table>
            <!-- end:: pending budget requests -->
            @endif

            <!-- start:: pending invoice requests -->
            @component('project::emails.common.invoice_requests_table', ['title' => 'Pending Invoice Requests', 'invoices' => $pendingInvoiceRequests, 'franchiseCurrency' => $franchiseCurrency])
            @endcomponent
            <!-- end:: pending invoice requests -->

            <!-- start:: approved invoice requests -->
            @component('project::emails.common.invoice_requests_table', ['title' => 'Approved Invoice Requests', 'invoices' => $approvedInvoiceRequests, 'franchiseCurrency' => $franchiseCurrency])
            @endcomponent
            <!-- end:: approved invoice requests -->

            <!-- start:: raised tax invoice requests -->
            @component('project::emails.common.invoice_requests_table', ['title' => 'Raised Tax Invoices', 'invoices' => $raisedTaxInvoices, 'franchiseCurrency' => $franchiseCurrency])
            @endcomponent
            <!-- end:: raised tax invoice requests -->

            @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])