@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-2" id="type">
                                    <p class="mg-b-10 parent-label"> {{ __('users.branch') }} </p>
                                    <select class="form-control parent-input" name="branch" required>
                                        <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
                                    </select>

                                </div class='row'>
                                <div class="col-lg-4 mg-t-20 mg-lg-t-0" id="type">
                                    <p class="mg-b-10 parent-label"> {{ __('home.searchbyclientname') }} </p>
                                    <select class="form-control parent-input select2" name="UserId" required>

                                        <option value="-"> {{ __('home.searchbyclientname') }}</option>

                                        @foreach (App\Models\customers::get() as $section)
                                            <option style="font-size: 15px" value="{{ $section->id }}"> {{ $section->name }} -
                                               </option>
                                        @endforeach
                                    </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: 10px" class="card m-3 p-3">
                        <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%">
                                <thead>
                                    <tr>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.Invoice_no') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.sallerName') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.clietName') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.quantity_thobe') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.date') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.branch') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.total') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">مدين (الرصيد الحالي)</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.thobe_status') }}</th>
                                        <th style="color: #FF4F1F; font-size: 12px;" class="border-bottom-0">{{ __('home.operations') }}</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $i = 0;
                                        // جلب قيمة الضريبة مرة واحدة خارج الحلقة لتحسين الأداء
                                        $avtModel = App\Models\Avt::find(1);
                                        $saleavt = $avtModel ? $avtModel->AVT : 0;
                                    @endphp

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

                                            // منطق الحالة (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';
                                            }

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

                                        <tr>
                                            <td>{{ $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: 15px;">{{ $product->created_at->format('Y-m-d H:i') }}</td>
                                            <td>{{ $product->branch->name ?? '' }}</td>
                                            <td style="color: #23395D; font-weight: bold;">
                                                {{ 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 ? '#ff0000' : '#28a745' }};">
                                                    {{ number_format($currentBalance, 2) }}
                                                </td>
                                            <td>
                                                <span class="badge {{ $badgeClass }}" style="font-size: 10px; padding: 5px 8px; min-width: 80px;">
                                                    {{ $statusText }}
                                                </span>
                                            </td>
                                            <td>
                                                <div class="d-flex align-items-center justify-content-center">
                                                    <!-- زر كشف الحساب -->
                                                    @if($product->customer && $product->customer->financial_account)
                                                        <button class="btn btn-sm btn-success ml-1 view-statement"
                                                                data-id="{{ $product->customer->financial_account->id }}"
                                                                title="{{ app()->getLocale() == 'ar' ? 'كشف حساب' : 'Account Statement' }}">
                                                            <i class="las la-file-invoice"></i>
                                                        </button>
                                                    @endif

                                                    <!-- زر الطباعة -->
                                                    <a href="showInvoiceRecent/{{ $product->id }}"
                                                    class="btn btn-sm text-white"
                                                    style="background-color: #23395D; 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>

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