@section('title', 'تقرير حركات التسوية والجرد')

@extends('layouts.master')

@section('css')
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<style>
    .card-report {
        border-radius: 8px;
        box-shadow: 0 2px 10px rgba(0,0,0,0.05);
    }
    .stat-card {
        border-radius: 8px;
        padding: 15px;
        color: #fff;
        margin-bottom: 15px;
    }
    .stat-blue   { background: linear-gradient(135deg, #007bff, #0056b3); }
    .stat-green  { background: linear-gradient(135deg, #28a745, #1e7e34); }
    .stat-red    { background: linear-gradient(135deg, #dc3545, #bd2130); }
    .stat-purple { background: linear-gradient(135deg, #6f42c1, #563d7c); }

    .table-report th {
        background-color: #f1f5f9 !important;
        color: #334155;
        font-size: 13px;
        font-weight: 600;
        vertical-align: middle !important;
    }
    .table-report td {
        vertical-align: middle !important;
    }

    /* تنسيقات الطباعة */
    @media print {
        .main-header, .main-sidebar-header, .side-menu, .breadcrumb-header, .filter-section, .btn-print, .pagination {
            display: none !important;
        }
        .main-content {
            margin: 0 !important;
            padding: 0 !important;
        }
        .card {
            border: none !important;
            box-shadow: none !important;
        }
        .table-responsive {
            overflow: visible !important;
        }
    }
</style>
@endsection

@section('content')
<!-- breadcrumb -->
<div class="breadcrumb-header justify-content-between">
    <div class="my-auto">
        <div class="d-flex">
            <h4 class="content-title mb-0 my-auto">{{ __('home.Stock_Reconciliation') ?? 'الجرد وتسوية المخزون' }}</h4>
            <span class="text-muted mt-1 tx-13 mr-2 mb-0">/ تقرير العمليات</span>
        </div>
    </div>
    <div class="d-flex my-xl-auto right-content">
        <button type="button" class="btn btn-outline-secondary btn-print ml-2" onclick="window.print()">
            <i class="fa fa-print ml-1"></i> طباعة التقرير
        </button>
    </div>
</div>
<!-- breadcrumb -->

{{-- 1. بطاقات المؤشرات الإحصائية العامة --}}
<div class="row">
    <div class="col-xl-3 col-lg-6 col-md-6">
        <div class="stat-card stat-blue shadow-sm">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h6 class="text-uppercase mb-1" style="opacity: 0.85;">إجمالي العمليات</h6>
                    <h3 class="mb-0 font-weight-bold">{{ $totalOperations }}</h3>
                </div>
                <i class="fa fa-file-invoice fa-2x" style="opacity: 0.7;"></i>
            </div>
        </div>
    </div>

    <div class="col-xl-3 col-lg-6 col-md-6">
        <div class="stat-card stat-purple shadow-sm">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h6 class="text-uppercase mb-1" style="opacity: 0.85;">إجمالي البنود / الأصناف</h6>
                    <h3 class="mb-0 font-weight-bold">{{ $totalItemsCount }}</h3>
                </div>
                <i class="fa fa-boxes fa-2x" style="opacity: 0.7;"></i>
            </div>
        </div>
    </div>

    <div class="col-xl-3 col-lg-6 col-md-6">
        <div class="stat-card stat-green shadow-sm">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h6 class="text-uppercase mb-1" style="opacity: 0.85;">قيمة الزيادة الجردية</h6>
                    <h3 class="mb-0 font-weight-bold">{{ number_format($totalSurplusValue, 2) }}</h3>
                </div>
                <i class="fa fa-arrow-up fa-2x" style="opacity: 0.7;"></i>
            </div>
        </div>
    </div>

    <div class="col-xl-3 col-lg-6 col-md-6">
        <div class="stat-card stat-red shadow-sm">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h6 class="text-uppercase mb-1" style="opacity: 0.85;">قيمة العجز الجردي</h6>
                    <h3 class="mb-0 font-weight-bold">{{ number_format($totalDeficitValue, 2) }}</h3>
                </div>
                <i class="fa fa-arrow-down fa-2x" style="opacity: 0.7;"></i>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-xl-12">
        <div class="card card-report">
            {{-- 2. شريط البحث والتصفية المتعدد --}}
            <div class="card-header border-bottom bg-light py-3 filter-section">
                <form action="{{ route('stock.report') }}" method="GET" class="row align-items-end">
                    <div class="col-md-3 form-group mb-2 mb-md-0">
                        <label class="form-label font-weight-bold small mb-1">الفرع:</label>
                        <select name="branch_id" class="form-control select2" style="width: 100%;">
                            <option value="">-- كل الفروع --</option>
                                                    </select>
                    </div>

                    <div class="col-md-2 form-group mb-2 mb-md-0">
                        <label class="form-label font-weight-bold small mb-1">نوع الحركة:</label>
                        <select name="type" class="form-control select2" style="width: 100%;">
                            <option value="">-- كل العمليات --</option>
                            <option value="reconciliation" {{ request('type') == 'reconciliation' ? 'selected' : '' }}>تسوية جردية</option>
                            <option value="branch_transfer" {{ request('type') == 'branch_transfer' ? 'selected' : '' }}>تحويل بين الفروع</option>
                            <option value="item_transfer" {{ request('type') == 'item_transfer' ? 'selected' : '' }}>تحويل صنف لصنف</option>
                        </select>
                    </div>

                    <div class="col-md-2 form-group mb-2 mb-md-0">
                        <label class="form-label font-weight-bold small mb-1">من تاريخ:</label>
                        <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}">
                    </div>

                    <div class="col-md-2 form-group mb-2 mb-md-0">
                        <label class="form-label font-weight-bold small mb-1">إلى تاريخ:</label>
                        <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}">
                    </div>

                    <div class="col-md-3 form-group mb-0 d-flex">
                        <button type="submit" class="btn btn-primary ml-2 px-4">
                            <i class="fa fa-search ml-1"></i> بحث
                        </button>
                        @if(request()->hasAny(['branch_id', 'type', 'from_date', 'to_date']))
                            <a href="{{ route('stock.report') }}" class="btn btn-outline-secondary">
                                <i class="fa fa-undo ml-1"></i> إعادة تعيين
                            </a>
                        @endif
                    </div>
                </form>
            </div>

            {{-- 3. جدول العمليات والتفاصيل المجمعة --}}
            <div class="card-body">
                <div class="table-responsive">
                  <table class="table table-bordered table-hover text-center table-report">
                        <thead>
                            <tr>
                                <th style="width: 40px;">#</th>
                                <th style="width: 140px;">رقم الإذن</th>
                                <th style="width: 110px;">تاريخ العملية</th>
                                <th style="width: 120px;">نوع الحركة</th>
                                <th>الفرع / المخزن</th>
                                <th style="min-width: 270px;">الأصناف المتأثرة والكميات</th>
                                <th style="width: 110px;">إجمالي التكلفة</th>
                                <th style="width: 110px;">المسؤول</th>
                                <th>ملاحظات</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if(isset($adjustments) && $adjustments->count() > 0)
                                @foreach($adjustments as $index => $adj)
                                    @php
                                        // حساب إجمالي قيمة البنود في الحركة
                                        $adjTotalCost = $adj->items->sum(function($item) {
                                            return abs($item->quantity) * (double) $item->cost_price;
                                        });
                                    @endphp
                                    <tr>
                                        <td class="font-weight-bold text-muted">{{ $adjustments->firstItem() + $index }}</td>
                                        <td class="font-weight-bold text-primary">{{ $adj->reference_no }}</td>
                                        <td>{{ $adj->adjustment_date ? $adj->adjustment_date->format('Y-m-d') : '-' }}</td>
                                        <td>
                                            @if($adj->type == 'reconciliation')
                                                <span class="badge badge-info px-2 py-1">تسوية جردية</span>
                                            @elseif($adj->type == 'branch_transfer')
                                                <span class="badge badge-warning px-2 py-1">تحويل فروع</span>
                                            @elseif($adj->type == 'item_transfer')
                                                <span class="badge px-2 py-1 text-white" style="background-color: #7e22ce;">تحويل صنف</span>
                                            @endif
                                        </td>
                                        <td>
                                            @if($adj->type == 'branch_transfer')
                                                <span>{{ $adj->fromBranch->name ?? ($adj->fromBranch->branch_name ?? '-') }}</span>
                                                <i class="fa fa-arrow-left text-success mx-1"></i>
                                                <span class="font-weight-bold text-success">{{ $adj->toBranch->name ?? ($adj->toBranch->branch_name ?? '-') }}</span>
                                            @else
                                                <span>{{ $adj->fromBranch->name ?? ($adj->fromBranch->branch_name ?? 'الفرع الرئيسي') }}</span>
                                            @endif
                                        </td>

                                        {{-- عمود الأصناف المتأثرة والكميات بتنسيق واضح ومنفصل --}}
                                        <td style="min-width: 270px; max-width: 320px;" class="text-right">
                                            @foreach($adj->items->take(3) as $item)
                                                <div class="d-flex justify-content-between align-items-center py-1 {{ !$loop->last ? 'border-bottom' : '' }}">
                                                    <div class="text-truncate mr-1" style="max-width: 190px;" title="{{ $item->product->product_name ?? '' }}">
                                                        <span class="badge badge-light border text-muted px-1">{{ $item->product->Product_Code ?? '-' }}</span>
                                                        <span class="font-weight-bold text-dark small">{{ $item->product->product_name ?? '-' }}</span>
                                                    </div>
                                                    <div>
                                                        @if($adj->type == 'branch_transfer')
                                                            <span class="badge badge-primary px-2 py-1 font-weight-bold" title="كمية محولة">
                                                                {{ $item->quantity }}
                                                            </span>
                                                        @elseif($adj->type == 'item_transfer')
                                                            <span class="badge px-2 py-1 font-weight-bold text-white" style="background-color: #7e22ce;" title="تحويل صنف">
                                                                {{ $item->quantity }}
                                                            </span>
                                                        @else
                                                            @if($item->quantity > 0)
                                                                <span class="badge badge-success px-2 py-1 font-weight-bold" title="زيادة جردية">
                                                                    +{{ $item->quantity }}
                                                                </span>
                                                            @elseif($item->quantity < 0)
                                                                <span class="badge badge-danger px-2 py-1 font-weight-bold" title="عجز جردي">
                                                                    {{ $item->quantity }}
                                                                </span>
                                                            @else
                                                                <span class="badge badge-secondary px-2 py-1 font-weight-bold" title="مطابق">
                                                                    0
                                                                </span>
                                                            @endif
                                                        @endif
                                                    </div>
                                                </div>
                                            @endforeach

                                            @if($adj->items->count() > 3)
                                                <div class="text-center mt-1">
                                                    <span class="badge badge-pill badge-light border text-primary small font-weight-bold py-1 px-2">
                                                        + {{ $adj->items->count() - 3 }} أصناف إضافية
                                                    </span>
                                                </div>
                                            @endif
                                        </td>

                                        <td class="font-weight-bold text-dark">
                                            {{ number_format($adjTotalCost, 2) }}
                                        </td>
                                        <td>{{ $adj->user->name ?? '-' }}</td>
                                        <td class="text-muted small" style="max-width: 150px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap;">
                                            {{ $adj->notes ?: '-' }}
                                        </td>
                                    </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td colspan="9" class="text-center py-5 text-muted font-weight-bold">
                                        <i class="fa fa-search fa-2x d-block mb-2 text-secondary"></i>
                                        لا توجد حركات مطابقة لمعايير البحث المحددة.
                                    </td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                </div>

                {{-- ترقيم الصفحات Pagination --}}
                @if(isset($adjustments) && $adjustments->hasPages())
                    <div class="d-flex justify-content-between align-items-center mt-4 border-top pt-3">
                        <div class="text-muted small">
                            عرض <strong>{{ $adjustments->firstItem() }}</strong> - <strong>{{ $adjustments->lastItem() }}</strong> من إجمالي <strong>{{ $adjustments->total() }}</strong> عملية
                        </div>
                        <div>
                            {{ $adjustments->appends(request()->query())->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                @endif
            </div>
        </div>
    </div>
</div>
@endsection

@section('js')
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script>
$(document).ready(function() {
    $('.select2').select2({ dir: "rtl", width: '100%' });
});
</script>
@endsection