@extends('layouts.app')

@section('title', 'Cash Register Report')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>Cash Register Report
        <small class="text-muted">Register Reconciliation & Variance Analysis</small>
    </h1>
</section>

<!-- Main content -->
<section class="content">
    @component('components.widget', ['class' => 'box-primary'])
        <div class="row">
            <div class="col-md-3 col-xs-12">
                <div class="form-group">
                    {!! Form::label('start_date', __('accounting-reports::lang.start_date') . ':') !!}
                    {!! Form::text('start_date', @format_date($report['summary']['start_date'] ?? now()->startOfMonth()), ['class' => 'form-control date-picker', 'readonly', 'id' => 'start_date']) !!}
                </div>
            </div>
            <div class="col-md-3 col-xs-12">
                <div class="form-group">
                    {!! Form::label('end_date', __('accounting-reports::lang.end_date') . ':') !!}
                    {!! Form::text('end_date', @format_date($report['summary']['end_date'] ?? now()->endOfMonth()), ['class' => 'form-control date-picker', 'readonly', 'id' => 'end_date']) !!}
                </div>
            </div>
            <div class="col-md-3 col-xs-12">
                <div class="form-group">
                    {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                    {!! Form::select('location_id', $locations ?? [], null, ['class' => 'form-control select2', 'placeholder' => __('messages.all'), 'style' => 'width:100%', 'id' => 'location_filter']) !!}
                </div>
            </div>
            <div class="col-md-3 col-xs-12">
                <div class="form-group">
                    <label>&nbsp;</label><br>
                    <button type="button" class="btn btn-primary" id="filter_btn">
                        <i class="fa fa-filter"></i> @lang('messages.filter')
                    </button>
                </div>
            </div>
        </div>
    @endcomponent

    <!-- Summary Cards -->
    <div class="row">
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-aqua">
                <span class="info-box-icon"><i class="fa fa-cash-register"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Total Registers</span>
                    <span class="info-box-number">{{ $report['summary']['total_registers'] ?? 0 }}</span>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-yellow">
                <span class="info-box-icon"><i class="fa fa-balance-scale"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Total Variance</span>
                    <span class="info-box-number">@format_currency($report['summary']['total_variance'] ?? 0)</span>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-green">
                <span class="info-box-icon"><i class="fa fa-arrow-up"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Total Over</span>
                    <span class="info-box-number">@format_currency($report['summary']['total_over'] ?? 0)</span>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-red">
                <span class="info-box-icon"><i class="fa fa-arrow-down"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Total Short</span>
                    <span class="info-box-number">@format_currency($report['summary']['total_short'] ?? 0)</span>
                </div>
            </div>
        </div>
    </div>

    <!-- Registers Table -->
    <div class="row">
        <div class="col-md-12">
            <div class="box box-solid">
                <div class="box-header with-border">
                    <h3 class="box-title">Register Details</h3>
                </div>
                <div class="box-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped table-hover">
                            <thead>
                                <tr>
                                    <th>Register ID</th>
                                    <th>User</th>
                                    <th>Location</th>
                                    <th>Opened At</th>
                                    <th>Closed At</th>
                                    <th>Opening Cash</th>
                                    <th>Cash Sales</th>
                                    <th>Cash Refunds</th>
                                    <th>Cash Expenses</th>
                                    <th>Expected Cash</th>
                                    <th>Actual Cash</th>
                                    <th>Variance</th>
                                    <th>Status</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($report['registers'] ?? [] as $register)
                                <tr>
                                    <td>{{ $register['register_id'] ?? 'N/A' }}</td>
                                    <td>{{ $register['user_name'] ?? 'N/A' }}</td>
                                    <td>{{ $register['location_name'] ?? 'N/A' }}</td>
                                    <td>{{ @format_datetime($register['opened_at'] ?? null) }}</td>
                                    <td>{{ @format_datetime($register['closed_at'] ?? null) }}</td>
                                    <td>@format_currency($register['opening_cash'] ?? 0)</td>
                                    <td>@format_currency($register['cash_sales'] ?? 0)</td>
                                    <td>@format_currency($register['cash_refunds'] ?? 0)</td>
                                    <td>@format_currency($register['cash_expenses'] ?? 0)</td>
                                    <td>@format_currency($register['expected_cash'] ?? 0)</td>
                                    <td>@format_currency($register['actual_cash'] ?? 0)</td>
                                    <td>
                                        <span class="label label-{{ 
                                            ($register['status'] ?? '') == 'over' ? 'success' : 
                                            (($register['status'] ?? '') == 'short' ? 'danger' : 'info') 
                                        }}">
                                            @format_currency($register['variance'] ?? 0)
                                        </span>
                                    </td>
                                    <td>
                                        <span class="label label-{{ 
                                            ($register['status'] ?? '') == 'over' ? 'success' : 
                                            (($register['status'] ?? '') == 'short' ? 'danger' : 'info') 
                                        }}">
                                            {{ ucfirst($register['status'] ?? 'N/A') }}
                                        </span>
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="13" class="text-center">No registers found for the selected period.</td>
                                </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

</section>

@endsection

@section('javascript')
<script type="text/javascript">
    $(document).ready(function() {
        // Date picker
        $('.date-picker').datepicker({
            autoclose: true,
            format: datepicker_date_format
        });

        // Filter button
        $('#filter_btn').on('click', function() {
            var startDate = $('#start_date').val();
            var endDate = $('#end_date').val();
            var locationId = $('#location_filter').val();
            
            var url = '{{ route("accounting-reports.cash-register.report") }}';
            url += '?start_date=' + startDate + '&end_date=' + endDate;
            if (locationId) {
                url += '&location_id=' + locationId;
            }
            
            window.location.href = url;
        });
    });
</script>
@endsection