@extends('layouts.master')
@section('css')
<style>
    /* تنسيقات الطباعة */
    @media print {
        #print_Button { display: none; }
        body { margin: 0; padding: 10px !important; border: none !important; }
        .main-content-body-invoice { border: none !important; }
    }

    /* تنسيق العناوين البارزة */
    .double {
        border: 2px solid #495057;
        border-radius: 8px;
        width: fit-content;
        padding: 10px 25px;
        font-size: 18px !important;
        font-weight: bold;
        background-color: #f8f9fa;
        display: inline-block;
        margin-bottom: 20px;
    }

    body {
        font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
        line-height: 1.6;
        color: #333;
    }

    .table thead th {
        background-color: #419BB2 !important;
        color: white !important;
        vertical-align: middle !important;
        border: 1px solid #dee2e6;
    }

    .total-row {
        background-color: #eee !important;
        font-weight: bold;
    }

    .invoice-logo { width: 120px; height: auto; }
</style>
@endsection

@section('title') {{ __('home.print') }} @stop

@section('content')
<div class="row row-sm">
    <div class="col-md-12 col-xl-12">
        <div class="main-content-body-invoice" id="print">
            <div class="card card-invoice">
                <div class="card-body">
                    
                    <div class="d-flex justify-content-center">
                        <button class="btn btn-danger float-left mt-3" id="print_Button" onclick="printDiv()">
                            {{ __('home.print') }} <i class="mdi mdi-printer ml-1"></i>
                        </button>
                    </div>

                    <div class="invoice-header d-flex justify-content-between align-items-center mt-4">
                        <div class="billed-from text-center" style="width:30%">
                            <h5 class="text-primary">{{ Namear }}</h5>
                            <p>{{ describtionar }}<br>{{ STar }}<br>{{ Taxar }}</p>
                        </div>
                        
                        <div class="text-center">
                            <img src="{{ asset('assets/img/brand/'.camplogo) }}" class="invoice-logo" alt="logo">
                        </div>

                        <div class="billed-from text-center" style="width:30%">
                            <h5 class="text-primary">{{ Nameen }}</h5>
                            <p dir="ltr">{{ describtionen }}<br>{{ STen }}<br>{{ Taxen }}</p>
                        </div>
                    </div>

                    <hr>

                    <div class="text-center mt-3">
                        <span class='double'>أرباح المبيعات & Sales Profits</span>
                    </div>

                    <table class="table table-bordered text-center my-3">
                        <tr style="background: #f0f4f8">
                            <th>{{ __('report.fromdate') }}: <b>{{ $start }}</b></th>
                            <th>{{ __('report.todate') }}: <b>{{ $end }}</b></th>
                            <th>{{ __('home.exportTime') }}: <b>{{ \Carbon\Carbon::now()->addHours(3)->format("Y-m-d H:i") }}</b></th>
                        </tr>
                    </table>

                    @php
                        $totalcost = 0; $totalsales = 0; $totaldiscount = 0; $totalprofit = 0; $quantity = 0;
                    @endphp

                    <h6 class="text-dark font-weight-bold"><i class="fas fa-shopping-cart"></i> تفاصيل المبيعات:</h6>
                    <div class="table-responsive">
                        <table class="table table-striped table-bordered text-center">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>{{ __('report.date') }}</th>
                                    <th>{{ __('home.product') }}</th>
                                    <th>{{ __('home.quantity') }}</th>
                                    <th>{{ __('home.purchaseproductwithouttax') }} (التكلفة)</th>
                                    <th>{{ __('home.total') }}</th>
                                    <th>{{ __('home.sellingproduct without tax') }}</th>
                                    <th>{{ __('home.total') }}</th>
                                    <th>{{ __('home.discount') }}</th>
                                    <th>{{ __('report.profit') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($data['sales'] as $index => $product)
                                @php
                                    // منطق المرتجع المرتبط بالسطر
                                    $returns = App\Models\return_sales::where('product_id', $product->product_id)->where('invoice_id', $product->invoice_id)->get();
                                    $netQty = $product->quantity + $returns->sum('return_quantity');
                                    
                                    // منطق التكلفة (Fallback)
                                    $costPrice = ($product->productData->average_cost > 0) 
                                                 ? $product->productData->average_cost 
                                                 : ($product->productData->purchasingـprice ?? 0);

                                    $lineCost = $costPrice * $netQty;
                                    $lineSales = $product->Unit_Price * $netQty;
                                    
                                    // توزيع الخصم العام
                                    $invoice = App\Models\invoices::find($product->invoice_id);
                                    //   $sharedDisc = ($invoice && $invoice->discount > 0) ? ($invoice->discount / (App\Models\sales::where('invoice_id', $product->invoice_id)->sum('quantity') ?: 1)) * $netQty : 0;
                                    $sharedDisc=0;
                                    $lineTotalDisc = $product->Discount_Value + $returns->sum('discountvalue') + $sharedDisc;

                                    $lineProfit = $lineSales - ($lineCost + $lineTotalDisc);

                                    // الإجماليات
                                    $quantity += $netQty; $totalcost += $lineCost; $totalsales += $lineSales; $totaldiscount += $lineTotalDisc; $totalprofit += $lineProfit;
                                @endphp
                                <tr>
                                    <td>{{ $index + 1 }}</td>
                                    <td>{{ $product->created_at->format('Y-m-d') }}</td>
                                    <td>{{ $product->productData->product_name ?? '-' }}</td>
                                    <td>{{ number_format($netQty, 2) }}</td>
                                    <td>{{ number_format($costPrice, 2) }}</td>
                                    <td>{{ number_format($lineCost, 2) }}</td>
                                    <td>{{ number_format($product->Unit_Price, 2) }}</td>
                                    <td>{{ number_format($lineSales, 2) }}</td>
                                    <td>{{ number_format($lineTotalDisc, 2) }}</td>
                                    <td class="font-weight-bold" style="color: {{ $lineProfit < 0 ? '#ff0000' : '#28a745' }}">
                                        {{ number_format($lineProfit, 2) }}
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr class="total-row">
                                    <td colspan="3">الإجمالي (M)</td>
                                    <td>{{ number_format($quantity, 2) }}</td>
                                    <td>-</td>
                                    <td>{{ number_format($totalcost, 2) }}</td>
                                    <td>-</td>
                                    <td>{{ number_format($totalsales, 2) }}</td>
                                    <td>{{ number_format($totaldiscount, 2) }}</td>
                                    <td>{{ number_format($totalprofit, 2) }}</td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>

                    <div class="mt-5 text-center">
                        <span class='double'>أرباح مرتجع المبيعات & Returns Profits</span>
                    </div>

                    @php
                        $totalcostreturn = 0; $totalsalesreturn = 0; $totaldiscountreturn = 0; $totalprofitreturn = 0; $quantityreturn = 0;
                    @endphp

                    <div class="table-responsive">
                        <table class="table table-striped table-bordered text-center">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>{{ __('home.product') }}</th>
                                    <th>{{ __('home.salesـreturned') }}</th>
                                    <th>التكلفة (عند المرتجع)</th>
                                    <th>إجمالي التكلفة</th>
                                    <th>سعر البيع</th>
                                    <th>إجمالي البيع</th>
                                    <th>{{ __('report.profit') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($data['returnsales'] as $index => $product)
                                @php
                                    $costPriceReturn = ($product->productData->average_cost > 0) ? $product->productData->average_cost : ($product->productData->purchasingـprice ?? 0);
                                    
                                    $rCost = $costPriceReturn * $product->return_quantity;
                                    $rSales = $product->return_Unit_Price * $product->return_quantity;
                                    $rDisc = ($product->discountoninvoice + $product->discountvalue);
                                    $rProfit = $rSales - ($rCost + $rDisc);

                                    $quantityreturn += $product->return_quantity;
                                    $totalcostreturn += $rCost;
                                    $totalsalesreturn += $rSales;
                                    $totalprofitreturn += $rProfit;
                                @endphp
                                <tr>
                                    <td>{{ $index + 1 }}</td>
                                    <td>{{ $product->productData->product_name ?? '-' }}</td>
                                    <td>{{ number_format($product->return_quantity, 2) }}</td>
                                    <td>{{ number_format($costPriceReturn, 2) }}</td>
                                    <td>{{ number_format($rCost, 2) }}</td>
                                    <td>{{ number_format($product->return_Unit_Price, 2) }}</td>
                                    <td>{{ number_format($rSales, 2) }}</td>
                                    <td>{{ number_format($rProfit, 2) }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    <div class="row mt-4 justify-content-end">
                        <div class="col-md-4">
                            <table class="table table-bordered text-right">
                                <tr class="bg-primary text-white">
                                    <th class="text-center" style="font-size: 20px;">صافي الربح النهائي</th>
                                </tr>
                                <tr>
                                    <td class="text-center">
                                        <h3 class="font-weight-bold {{ ($totalprofit - $totalprofitreturn) < 0 ? 'text-danger' : 'text-success' }}">
                                            {{ number_format($totalprofit - $totalprofitreturn, 2) }} ريال
                                        </h3>
                                    </td>
                                </tr>
                            </table>
                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('js')
<script type="text/javascript">
    function printDiv() {
        var printContents = document.getElementById('print').innerHTML;
        var originalContents = document.body.innerHTML;
        document.body.innerHTML = printContents;
        window.print();
        document.body.innerHTML = originalContents;
        location.reload();
    }
</script>
@endsection