@extends('admin.master')
@section('title', 'Customer Ledger Report')

@section('page_css')
<style>
    /* Filter Card Styling */
    .filter-card {
        background: #fff;
        border-radius: 10px;
        box-shadow: 0 4px 15px rgba(0, 0, 0, 0.05);
        padding: 20px 25px;
        margin-bottom: 25px;
        border: 1px solid #eef2f3;
    }
    .filter-title {
        font-size: 16px;
        font-weight: 700;
        color: #2b2b2b;
        margin-bottom: 20px;
        border-left: 4px solid #00c292;
        padding-left: 12px;
    }
    .form-group label {
        font-weight: 600;
        color: #444;
        margin-bottom: 8px;
        display: block;
    }
    .form-group label i { margin-right: 5px; color: #555; }
    .custom-input {
        border-radius: 4px !important;
        border: 1px solid #dce4ec;
        height: 38px;
        box-shadow: none;
        background-color: #f8f9fa;
    }
    
    /* Button Styling */
    .btn-custom {
        background-color: #00c292;
        border: none;
        color: #fff;
        height: 38px;
        padding: 0 20px;
        font-weight: 700;
        border-radius: 4px;
        margin-top: 25px;
        width: 100%;
        transition: 0.3s;
        display: flex;
        align-items: center;
        justify-content: center;
        gap: 8px;
    }
    .btn-custom:hover { background-color: #00a67c; color: #fff; }

    /* Customer Ledger Header Styling */
    .party-ledger-header {
        text-align: center;
        margin-bottom: 30px;
        color: #000;
        font-family: 'Times New Roman', Times, serif;
    }
    .party-ledger-header .company-name {
        font-size: 22px;
        font-weight: bold;
        margin-bottom: 8px;
        text-transform: uppercase;
    }
    .party-ledger-header .report-title {
        font-size: 18px;
        font-weight: bold;
        margin-bottom: 15px;
    }
    .party-ledger-header .customer-name {
        font-size: 20px;
        font-weight: bold;
        text-transform: uppercase;
        margin-bottom: 25px;
    }
    .customer-info-grid {
        display: flex;
        justify-content: space-between;
        text-align: left;
        max-width: 800px;
        margin: 0 auto 20px auto;
        font-size: 15px;
        font-weight: bold;
    }
    .customer-info-grid p { margin-bottom: 8px; }
    .customer-info-grid span { font-weight: normal; }

    /* Hide Print Footer on Screen */
    @media screen {
        .print-footer-section { display: none !important; }
    }

    /* Print View CSS - Strictly Black and White Table */
    @media print {
        .non-printable, .main-sidebar, .main-header, .footer, .bg-title { 
            display: none !important; 
        }
        .content-wrapper {
            margin: 0 !important;
            padding: 0 !important;
            background-color: #fff !important;
            width: 100% !important;
        }
        
        .party-ledger-header { margin-top: 20px; }

        /* Force Print Content to Black and White */
        #printableArea, #printableArea * {
            color: #000 !important;
            background: transparent !important;
            background-color: #fff !important;
            border-color: #000 !important;
            box-shadow: none !important;
            text-shadow: none !important;
            -webkit-print-color-adjust: exact !important;
            print-color-adjust: exact !important;
        }

        table {
            width: 100% !important;
            border-collapse: collapse !important;
        }
        table th, table td {
            border: 1px solid #000 !important;
            padding: 8px !important;
        }
        table th {
            font-weight: bold !important;
        }

        /* Print Footer Fixed at Bottom Left */
        .print-footer-section {
            display: block !important;
            position: fixed;
            bottom: 10px;
            left: 15px;
            font-size: 12px;
            font-weight: bold;
            color: #000 !important;
        }

        @page {
            size: auto;
            margin: 10mm 10mm 20mm 10mm; /* Extra margin for footer space */
        }
    }
</style>
@endsection

@section('content')
<div class="container-fluid">
    <div class="row bg-title page-breadcrumb bg-white non-printable">
        <div class="col-lg-12">
            <ol class="breadcrumb">
                <li class="active breadcrumbColor"><a href="{{ url('dashboard') }}"><i class="fa fa-home"></i> Dashboard</a></li>
                <li>@yield('title')</li>
            </ol>
        </div>
    </div>

    <div class="row non-printable">
        <div class="col-md-12">
            <div class="filter-card">
                <div class="filter-title">Filter Ledger Report</div>
                
                {{ Form::open(['route' => 'report.customer_ledger_report', 'method' => 'POST', 'class' => 'form-horizontal']) }}
                <div class="row">
                    <div class="col-md-3">
                        <div class="form-group" style="padding: 0 10px;">
                            <label><i class="fa fa-calendar"></i> From Date</label>
                            {!! Form::text('start_date', $start_date, ['class'=>'form-control custom-input start_date', 'required'=>'required', 'readonly']) !!}
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group" style="padding: 0 10px;">
                            <label><i class="fa fa-calendar-check-o"></i> End Date</label>
                            {!! Form::text('end_date', $end_date, ['class'=>'form-control custom-input end_date', 'required'=>'required', 'readonly']) !!}
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group" style="padding: 0 10px;">
                            <label><i class="fa fa-user"></i> Select Customer <span class="text-danger">*</span></label>
                            {{ Form::select('customer_id', $customer, is_scalar($customer_id) ? $customer_id : null, ['id' => 'customer_id_select', 'class' => 'form-control custom-input select2', 'placeholder' => '--- Choose Customer ---', 'required']) }}
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div style="padding: 0 10px; display: flex; gap: 10px;">
                            <button type="submit" class="btn btn-custom">
                                <i class="fa fa-search"></i> SEARCH
                            </button>
                            
                            <button type="button" onclick="printLedger('printableArea')" class="btn btn-custom">
                                <i class="fa fa-print"></i> PRINT
                            </button>
                        </div>
                    </div>
                </div>
                {{ Form::close() }}
            </div>
        </div>
    </div>

    <div class="row" id="printableArea">
        <div class="col-md-12">
            
            @if(isset($customer_id) && $customer_id != '')
            
            @php
                // Fetching customer details directly from the database
                $selected_customer_name = is_scalar($customer_id) && isset($customer[$customer_id]) ? $customer[$customer_id] : '---';
                
                $customer_phone = 'N/A';
                $customer_code = 'N/A';
                $sales_person = 'N/A';
                
                try {
                    $cust_data = \DB::table('customers')->where('id', $customer_id)->first();
                    if($cust_data) {
                        $customer_phone = $cust_data->phone ?? $cust_data->mobile ?? 'N/A';
                        $customer_code = $cust_data->code ?? 'N/A';
                        
                        // Fetching the user who created this customer
                        $creator_id = $cust_data->created_by ?? $cust_data->user_id ?? null;
                        if($creator_id) {
                            $user_data = \DB::table('users')->where('id', $creator_id)->first();
                            $sales_person = $user_data ? $user_data->name : 'N/A';
                        }
                    }
                } catch (\Exception $e) {
                    // Fail gracefully if column names don't exactly match
                }
            @endphp

            <div class="party-ledger-header">
                <div class="company-name">GOODLUCK iT</div>
                <div class="report-title">Customer Ledger Report</div>
                
                <div class="customer-name">
                    {{ $selected_customer_name }}
                </div>
                
                <div class="customer-info-grid">
                    <div class="info-left">
                        <p>Code: <span>{{ $customer_code }}</span></p>
                        <p>Phone: <span>{{ $customer_phone }}</span></p>
                    </div>
                    <div class="info-right">
                        <p>Sales Person : <span>{{ $sales_person }}</span></p>
                        <p>Payment Term: <span></span></p>
                    </div>
                </div>
            </div>
            @endif
            
            @include('admin.report.customer_ledger_report_data')

            <div class="print-footer-section">
                Printed On: {{ \Carbon\Carbon::now()->timezone('Asia/Dhaka')->format('d-M-Y h:i A') }} | Printed By: {{ Auth::user()->name ?? 'Admin' }}
            </div>

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

@section('page_scripts')
<script>
    /* Initialize datepickers and select2 */
    $(document).ready(function() {
        if($('.select2').length) { $('.select2').select2(); }

        $(document).on("focus", ".start_date, .end_date", function () {
            $(this).datepicker({ format: 'yyyy-mm-dd', todayHighlight: true, autoclose: true });
        });
    });

    /* Professional Print function */
    function printLedger(divName) {
        var customerName = $('#customer_id_select option:selected').text().trim();
        if (customerName === '--- Choose Customer ---' || customerName === '') {
            customerName = 'Customer';
        }
        var fromDate = "{{ $start_date ?? '' }}";
        var toDate = "{{ $end_date ?? '' }}";
        var originalTitle = document.title;

        var safeName = customerName.replace(/[^a-z0-9\u0980-\u09FF]/gi, '_');
        document.title = safeName + "_Ledger_" + fromDate + "_to_" + toDate;

        var printContents = document.getElementById(divName).innerHTML;
        var originalContents = document.body.innerHTML;

        document.body.innerHTML = printContents;
        window.print();
        
        document.body.innerHTML = originalContents;
        document.title = originalTitle;
        location.reload(); 
    }
</script>
@endsection