@extends('layouts.master')
@section('css')
    <!-- Internal Data table css -->
    <link href="{{ URL::asset('assets/plugins/datatable/css/dataTables.bootstrap4.min.css') }}" rel="stylesheet" />
    <link href="{{ URL::asset('assets/plugins/datatable/css/buttons.bootstrap4.min.css') }}" rel="stylesheet">
    <link href="{{ URL::asset('assets/plugins/datatable/css/responsive.bootstrap4.min.css') }}" rel="stylesheet" />
    <link href="{{ URL::asset('assets/plugins/datatable/css/jquery.dataTables.min.css') }}" rel="stylesheet">
    <link href="{{ URL::asset('assets/plugins/datatable/css/responsive.dataTables.min.css') }}" rel="stylesheet">
    <link href="{{ URL::asset('assets/plugins/select2/css/select2.min.css') }}" rel="stylesheet">

    <!-- Internal Spectrum-colorpicker css -->
    <link href="{{ URL::asset('assets/plugins/spectrum-colorpicker/spectrum.css') }}" rel="stylesheet">

    <!-- Internal Select2 css -->
    <link href="{{ URL::asset('assets/plugins/select2/css/select2.min.css') }}" rel="stylesheet">

@section('title')
    {{ __('report.customerـpurchases') }}@stop
@endsection
@section('page-header')
    <div class="main-parent">
        <!-- breadcrumb -->
        <div class="breadcrumb-header justify-content-between parent-heading">
            <div class="my-auto">
                <div class="d-flex">
                    <h4 class="content-title mb-0 my-auto">{{ __('report.customerـpurchases') }}

                    </h4><span class="text-muted mt-1 tx-13 mr-2 mb-0">
                    </span>
                </div>
            </div>
        </div>
        <!-- breadcrumb -->
    @endsection
    @section('content')

        @if (count($errors) > 0)
            <div class="alert alert-danger">
                <button aria-label="Close" class="close" data-dismiss="alert" type="button">
                    <span aria-hidden="true">&times;</span>
                </button>
                <strong>خطا</strong>
                <ul>
                    @foreach ($errors->all() as $error)
                        <li>{{ $error }}</li>
                    @endforeach
                </ul>
            </div>
        @endif

        <!-- row -->
        <div class="row">

            <div class="col-xl-12">
                <div class="card mg-b-20">


                    <div class="card-header pb-0">

                        <form
                            action="{{ url(Mcamara\LaravelLocalization\Facades\LaravelLocalization::getCurrentLocale() . '/' . ($page = 'customerـpurchases')) }}"
                            method="POST" role="search" autocomplete="off">
                            {{ csrf_field() }}

                            <div class="row">

                                <div class="col-lg-3" id="start_at">
                                    <label class="parent-label" for="exampleFormControlSelect1"> {{ __('report.fromdate') }}</label>
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <div class="input-group-text">
                                                <i class="fas fa-calendar-alt"></i>
                                            </div>
                                        </div><input id="start_at_input" class="form-control parent-input fc-datepicker"
                                            name="start_at" placeholder="YYYY-MM-DD" value="{{ $start }}" type="text" required>
                                    </div><!-- input-group -->
                                </div>

                                <div class="col-lg-3" id="end_at">
                                    <label class="parent-label" for="exampleFormControlSelect1"> {{ __('report.todate') }}</label>
                                    <div class="input-group">
                                        <div class="input-group-prepend">
                                            <div class="input-group-text">
                                                <i class="fas fa-calendar-alt"></i>
                                            </div>
                                        </div><input id="end_at_input" class="form-control parent-input fc-datepicker" name="end_at"
                                            placeholder="YYYY-MM-DD" value="{{ $end }}" type="text" required>
                                    </div><!-- input-group -->

                                </div>

                            <div class="col-lg-3 parent-label" id="end_at">
                                <p class="mg-b-10 parent-label"> {{ __('users.branch') }} </p>
                                <select class="form-control parent-input" name="branch" required>

                                    @if(in_array('Admin', Auth()->user()->roles_name ?? []) || in_array('Manger', Auth()->user()->roles_name ?? []))

                                        <option value="-" selected>{{ __('users.allbranchs') }}</option>
                                        @foreach (App\Models\branchs::get() as $branch)
                                            <option style="font-size: 15px" value="{{ $branch->id }}">
                                                {{ $branch->name }}
                                            </option>
                                        @endforeach

                                    @else

                                        <option style="font-size: 15px" value="{{ Auth()->user()->branchs_id }}" selected>
                                            {{ Auth()->user()->branch->name }}
                                        </option>

                                    @endif

                                </select>
                            </div>
                                <div class="col-lg-3 mg-t-20 mg-lg-t-0" id="type">
                                    <p class="mg-b-10 parent-label"> بحث باسم العميل أو رقم الجوال </p>
                                    <select class="form-control parent-input" id="customer-search" name="UserId" required>
                                        <option value="-" selected>{{ __('home.searchbyclientname') }}</option>
                                    </select>
                                </div><!-- col-4 -->

                            </div><br>
                            <div class="d-flex justify-content-center mb-3">
                                <button class="btn btn-success print-style p-1">
                                    {{ __('home.search') }}
                                    <i
                                        style=" height: 100;

                                                 font-size:15px"
                                        class="las la-search"></i>
                                </button>
                            </div>


                        </form>

                    </div>
                    @if (isset($Invoices))
                    <div style="border-radius: 12px; box-shadow: 0 4px 12px rgba(0,0,0,0.08);" class="card m-3 p-4">
                        <div class="table-responsive">
                                                                                                    <div class="table-responsive hoverable-table">
                      <table class="table table-hover table-bordered mb-0" id="example1" data-page-length='50' style="text-align: center; width:100%; border-radius: 8px; overflow: hidden; box-shadow: 0 2px 8px rgba(0,0,0,0.1);">
                                <thead>
                                    <tr style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white;">
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">#</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.Invoice_no') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.sallerName') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.clietName') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.quantity_thobe') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.date') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.branch') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.total') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">مدين (الرصيد الحالي)</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.thobe_status') }}</th>
                                        <th style="font-size: 13px; font-weight: 700; padding: 12px 8px;">{{ __('home.operations') }}</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $i = 0;
                                        $seq = 0;
                                        // جلب قيمة الضريبة مرة واحدة خارج الحلقة لتحسين الأداء
                                        $avtModel = App\Models\Avt::find(1);
                                        $saleavt = $avtModel ? $avtModel->AVT : 0;

                                        // متغيرات الملخص
                                        $grandTotal = 0;
                                        $grandDiscount = 0;
                                        $grandTax = 0;
                                        $grandAmount = 0;
                                        $invoiceCount = 0;
                                        $totalThobes = 0;
                                    @endphp

                                    @foreach ($Invoices as $product)
                                        @php
                                            if ($i == 0) { $startat = $product->created_at; }
                                            $endat = $product->created_at;
                                            $i++;
                                            $seq++;

                                            // منطق الحالة (Status Logic)
                                            $status = $product->status_invoice;
                                            switch ($status) {
                                                case 'NOT_STARTED':
                                                    $statusText = 'لم يبدأ';
                                                    $badgeClass = 'badge-danger';
                                                    break;
                                                case 'IN_PROGRESS':
                                                    $statusText = 'قيد التنفيذ';
                                                    $badgeClass = 'badge-warning';
                                                    break;
                                                case 'COMPLETED':
                                                    $statusText = 'تم الانتهاء';
                                                    $badgeClass = 'badge-success';
                                                    break;
                                                default:
                                                    $statusText = $status;
                                                    $badgeClass = 'badge-secondary';
                                            }

                                            // حساب الإجمالي شامل الضريبة
                                            $subtotal = $product->Price - $product->discount;
                                            $totalPrice = $subtotal * (1 + $saleavt);
                                            $taxAmount = $subtotal * $saleavt;

                                            // تجميع الإجماليات
                                            $grandTotal += $subtotal;
                                            $grandDiscount += $product->discount;
                                            $grandTax += $taxAmount;
                                            $grandAmount += $totalPrice;
                                            $invoiceCount++;
                                            $totalThobes += $product->sales->sum('quantity');
                                        @endphp

                                        <tr style="transition: all 0.2s;">
                                            <td style="font-weight: 700; color: #667eea;">{{ $seq }}</td>
                                            <td style="font-weight: 600;">{{ $product->id }}</td>
                                            <td>{{ $product->user->name ?? 'N/A' }}</td>
                                            <td style="font-weight: bold;" dir="auto">{{ $product->customer->name ?? '' }}</td>
                                            <td style="font-weight: bold;">{{ $product->sales->sum('quantity') }}</td>
                                            <td style="font-size: 14px;">{{ $product->created_at->format('Y-m-d H:i') }}</td>
                                            <td>{{ $product->branch->name ?? '' }}</td>
                                            <td style="color: #667eea; font-weight: 700; font-size: 15px;">
                                                {{ number_format($totalPrice, 2) }}
                                            </td>
                                            @php
                                                    // جلب رصيد العميل الحالي من الحساب المالي المرتبط به
                                                    $currentBalance = 0;
                                                    if($product->customer && $product->customer->financial_account) {
                                                        $account = $product->customer->financial_account;
                                                        // حساب الصافي (مدين - دائن)
                                                        $currentBalance = $account->credit_transactions->where('save', 1)->sum('debtor')
                                                                        - $account->credit_transactions->where('save', 1)->sum('creditor');
                                                    }
                                                @endphp

                                                <td style="font-weight: bold; color: {{ $currentBalance > 0 ? '#dc3545' : '#28a745' }}; font-size: 14px;">
                                                    {{ number_format($currentBalance, 2) }}
                                                </td>
                                            <td>
                                                <span class="badge {{ $badgeClass }}" style="font-size: 11px; padding: 6px 10px; min-width: 80px; border-radius: 6px;">
                                                    {{ $statusText }}
                                                </span>
                                            </td>
                                            <td>
                                                <div class="d-flex align-items-center justify-content-center gap-1">
                                                    <!-- زر كشف الحساب -->
                                                    @if($product->customer && $product->customer->financial_account)
                                                        <button class="btn btn-sm btn-success view-statement"
                                                                data-id="{{ $product->customer->financial_account->id }}"
                                                                title="{{ app()->getLocale() == 'ar' ? 'كشف حساب' : 'Account Statement' }}"
                                                                style="padding: 5px 10px; border-radius: 6px;">
                                                            <i class="las la-file-invoice"></i>
                                                        </button>
                                                    @endif

                                                    <!-- زر الطباعة -->
                                                    <a href="showInvoiceRecent/{{ $product->id }}"
                                                    class="btn btn-sm text-white"
                                                    style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); padding: 5px 10px; border-radius: 6px; display: flex; align-items: center;"
                                                    title="{{ __('home.show') }}">
                                                        <i class="fas fa-print mr-1"></i>
                                                        <span style="font-size: 11px;">{{ __('home.show') }}</span>
                                                    </a>
                                                </div>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>

                                        </div>
                                    </table>

                                    <!-- ملخص الإجماليات -->
                                    @if (count($Invoices) > 0)
                                    <div class="row mt-4">
                                        <div class="col-12">
                                            <div class="card" style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); border-radius: 12px; padding: 20px; box-shadow: 0 4px 15px rgba(102, 126, 234, 0.3);">
                                                <h5 class="text-white mb-3" style="font-weight: 700; font-size: 16px;">
                                                    <i class="fas fa-chart-pie ml-2"></i> ملخص الإجماليات
                                                </h5>
                                                <div class="row">
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="bg-white rounded p-3" style="box-shadow: 0 2px 8px rgba(0,0,0,0.1);">
                                                            <small class="text-muted d-block mb-1" style="font-size: 12px;">إجمالي المبلغ (بدون ضريبة)</small>
                                                            <strong style="font-size: 18px; color: #667eea;">{{ number_format($grandTotal, 2) }} ريال</strong>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="bg-white rounded p-3" style="box-shadow: 0 2px 8px rgba(0,0,0,0.1);">
                                                            <small class="text-muted d-block mb-1" style="font-size: 12px;">إجمالي الضريبة المضافة</small>
                                                            <strong style="font-size: 18px; color: #764ba2;">{{ number_format($grandTax, 2) }} ريال</strong>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="bg-white rounded p-3" style="box-shadow: 0 2px 8px rgba(0,0,0,0.1);">
                                                            <small class="text-muted d-block mb-1" style="font-size: 12px;">إجمالي الخصومات</small>
                                                            <strong style="font-size: 18px; color: #dc3545;">{{ number_format($grandDiscount, 2) }} ريال</strong>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3 col-6 mb-3">
                                                        <div class="bg-white rounded p-3" style="box-shadow: 0 2px 8px rgba(0,0,0,0.1);">
                                                            <small class="text-muted d-block mb-1" style="font-size: 12px;">الإجمالي النهائي (شامل الضريبة)</small>
                                                            <strong style="font-size: 20px; color: #28a745;">{{ number_format($grandAmount, 2) }} ريال</strong>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row mt-2">
                                                    <div class="col-md-4 col-6">
                                                        <div class="text-white d-flex align-items-center">
                                                            <i class="fas fa-file-invoice ml-2" style="font-size: 20px;"></i>
                                                            <div>
                                                                <small style="font-size: 12px; opacity: 0.9;">عدد الفواتير</small>
                                                                <div style="font-size: 18px; font-weight: 700;">{{ count($Invoices) }} فاتورة</div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4 col-6">
                                                        <div class="text-white d-flex align-items-center">
                                                            <i class="fas fa-tshirt ml-2" style="font-size: 20px;"></i>
                                                            <div>
                                                                <small style="font-size: 12px; opacity: 0.9;">إجمالي عدد الأثواب</small>
                                                                <div style="font-size: 18px; font-weight: 700;">{{ $Invoices->sum(function($inv) { return $inv->sales->sum('quantity'); }) }} ثوب</div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    @endif

<br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;App\Models\Avt&quot; not found in /home/ebdea/public_html/sewing.ebdea.online/resources/views/reports/customerpurchases.blade.php:347
Stack trace:
#0 {main}
  thrown in <b>/home/ebdea/public_html/sewing.ebdea.online/resources/views/reports/customerpurchases.blade.php</b> on line <b>347</b><br />