@php
if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code)
$currencyCode = Auth::user()->franchise->countries->currency_code;
else
$currencyCode = 'TZS';
@endphp

<table>
    <!-- start:: table head -->
    <thead>

        <tr>
            <th colspan="10"></th>
            <th colspan="4"></th>
            <th colspan="5"></th>
            <th colspan="5"></th>
            <th colspan="6"></th>
            <th colspan="6"></th>
            <th colspan="4"></th>
            <th colspan="2"></th>
        </tr>
        <tr>
            <th>S/N</th>
            <th>Customer Name</th>
            <th>Customer Number</th>
            <th>Customer Type</th>
            <th>Customer Location</th>
            <th>Agent Name</th>
            <th>LG Date</th>
            <th>Fulfillment Date</th>
            <th>LG Commission</th>
            <th>Sales Date</th>

            <!-- Product Information -->
            <th>Client</th>
            <th>Product</th>
            <th>Reference Number</th>
            <th>Sale Amount</th>

            <!-- CI Information -->
            <th>Customer TIN</th>
            <th>ID type</th>
            <th>ID Number</th>
            <th>CI Commission</th>
            <th>SC Commission</th>


            <!-- Attachments -->
            <th>Customer ID</th>
            <th>Product Form</th>
            <th>Business Licence</th>
            <th>Proof of Payment</th>
            <th>Proof of Branding</th>

            <!-- Branch Information -->
            <th>Branch Sent Date</th>
            <th>Branch Submitted By</th>
            <th>Received Date</th>
            <th>Received by</th>
            <th>Submmission status</th>
            <th>Branch Commission</th>

            <!-- HQ Information -->
            <th>HQ Sent Date</th>
            <th>HQ Submitted Date</th>
            <th>HQ Received Date</th>
            <th>HQ Received by</th>
            <th>HQ Status</th>
            <th>HQ Commission</th>

            <!-- After Sales Activity -->
            <th>Completion Date</th>
            <th>Completion status</th>
            <th>Completed by</th>
            <th>After Sales Commission</th>

            <!-- Commission Information -->
            <th>Total Commission</th>
            <th>Status</th>
        </tr>
    </thead>
    <!-- end:: table head -->
    <!-- start:: table body -->
    <tbody>
        @foreach($salesList as $key => $sale)
                <tr>
            <td style="border: 1px solid black;">{{ $key+1 }}</td>
            <td style="border: 1px solid black;">{{ $sale->kuaCustomer->customer_type == 'individual' ? $sale->kuaCustomer->full_name : $sale->kuaCustomer->registered_company_name }}</td>
            <td style="border: 1px solid black;">{{ $phone_number ? $phone_number : '-' }}</td>
            <td style="border: 1px solid black;">{{ ucfirst($sale->kuaCustomer->customer_type) }}</td>
            <td style="border: 1px solid black;">{{ $sale->kuaRegion->region_name ? $sale->kuaRegion->region_name : '-' }}</td>
            <td style="border: 1px solid black;">{{ $sale->kuaAgent->full_name }}</td>
            <td style="border: 1px solid black;">{{ $sale->created_at ? $sale->created_at->format('d-M-y') : '-' }}</td>
            <td style="border: 1px solid black;">{{ $sale->expected_closure_date ? $sale->expected_closure_date->format('d-M-y') : '-' }}</td>
            <td style="border: 1px solid black;">{{ $leadGenerationCommission ? (float)str_replace(',','',$leadGenerationCommission['stage_commission_value']) : 0 }}</td>
            <td style="border: 1px solid black;">{{ $saleDateResult ? Carbon\Carbon::parse($saleDateResult['answer'])->format('d-M-y') : '-' }}</td>

            <!-- Product Information -->
            <td style="border: 1px solid black;">{{ $sale->kuaCompany->name ? $sale->kuaCompany->name : '-' }}</td>
            <td style="border: 1px solid black;">{{ $sale->kuaProduct->product_name ? $sale->kuaProduct->product_name : '-' }}</td>
            <td style="border: 1px solid black;">{{ $referenceNumberResult ? $referenceNumberResult['answer'] : '-' }}</td>
            <td style="border: 1px solid black;">{{ $sale->sales_amount ? $sale->sales_amount : 0 }}</td>

            <!-- CI Information -->
            <td style="border: 1px solid black;">{{ $sale->kuaCustomer->tin }}</td>
            <td style="border: 1px solid black;">{{ $sale->kuaCustomer->kuaNationalIdType ? $sale->kuaCustomer->kuaNationalIdType->title : '-' }}</td>
            <td style="border: 1px solid black;">{{ $sale->kuaCustomer->national_id_number ? $sale->kuaCustomer->national_id_number : '-' }}</td>
            <td style="border: 1px solid black;">{{ $ciCommission ? (float)str_replace(',','',$ciCommission['stage_commission_value']) : 0 }}</td>
            <td style="border: 1px solid black;">{{ $scCommission ? (float)str_replace(',','',$scCommission['stage_commission_value'] ): 0 }}</td>