@extends('layouts.app')
@section('main-content')
<style>
    .bottom-aligner {
        display: inline-block;
        height: 100%;
        vertical-align: bottom;
        width: 3px;
        background: red;
    }

    .bottom-content {
        display: inline-block;
    }

    #calc {
        font-size: 0.8em;
        color: gray;
    }

    td,
    th {
        padding: 10px 5px 10px 10px !important;
        font-size: 0.9em;
        word-spacing: 1.5;
    }
</style>
<div class="container-fluid p-0">
    <nav class="page-breadcrumb">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Home</a></li>
            <li class="breadcrumb-item">Purchase Report</li>
        </ol>
    </nav>
    <h1 class="h3 mb-3"><strong>Purchase</strong> Report</h1>

    <div class="row">
        <div class="col-12">
            <div class="card flex-fill px-1">
                <div class="card-header d-flex justify-content-between">
                    <h5 class="card-title mb-0">Purchase Report</h5>
                </div>
                <div class="card-body mt-0 pt-0">
                    @if ($errors->any())
                    <div class="alert alert-danger">
                        <ul>
                            @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                            @endforeach
                        </ul>
                    </div>
                    @endif
                    <div class="row">
                        <form action="{{ route('reports.purchasereports') }}" method="GET">
                            <div class="col-12 d-flex">
                                <div class="col-md-2">
                                    <div class="col-md-4 d-flex">
                                        <div class="form-group text-nowrap">
                                            <label for="datefrom">Date From</label>
                                            <input type="date" name="datefrom" value="2025-03-01" class="form-control" id="datefrom">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-2">
                                    <div class="col-md-4 d-flex">
                                        <div class="form-group text-nowrap">
                                            <label for="dateto">Date To</label>
                                            <input type="date" name="dateto" value="2025-03-31" class="form-control" id="dateto">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-sm-1">
                                    <div class="col-md-2 d-flex">
                                        <div class="form-group text-nowrap">
                                            <label for="ob_filter">Open Bal.</label>
                                            <div class="d-flex align-items-end">
                                                <div class="d-inline-flex pt-2">
                                                    <input type="checkbox" class="pt-3"  name="ob_filter" id="ob_filter" value="1">
                                                    <span class="px-2">Hide</span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-2 d-flex align-items-end">
                                    <div class="col-md-4 d-flex">
                                        <div class="form-group text-nowrap">
                                            <button type="submit" class="btn btn-primary form-control" id="submit">Submit</button>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                    <div class="table-responsive pt-3">
                        <table id="table-purchases" class="table table-striped table-hover">
                            <thead>
                                <th>#</th>
                                <th class="text-nowrap">DO Number</th>
                                <th>Vendor</th>
                                <th class="text-nowrap">Product Name</th>
                                <th class="text-nowrap">Purchase Date</th>
                                <th class="text-nowrap text-end">Unit Price (RM)</th>
                                <th class="text-center">Quantity</th>
                                <th class="text-nowrap text-end">Amount (RM)</th>
                                @role('Super Admin|Admin|Product Manager')
                                <th class="text-end pe-2">Action</th>
                                @endrole
                            </thead>
                            @if(!empty($purchaseReports))
                            <tbody>
                                @php $purchase_cost = 0; @endphp
                                @forelse($purchaseReports as $report)
                                @php $purchase_cost += $report->costs > 0 ? $report->costs : -$report->carry @endphp
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $report->do_number == null ?  ($report->trans == 'AI' || $report->trans == 'AO' ? 'ADJ'.date('mY', strtotime($report->created_at)) : '') : $report->do_number }}</td>
                                    <td>{{ $report->vendor_name == null ? '' : $report->vendor_name }}</td>
                                    <td>{{ $report->product_name }}</td>
                                    <td class="text-nowrap">{{ date('Y-m-d H:i', strtotime($report->created_at)) }}</td>
                                    <td class="text-end">{{ number_format($report->unit_price, 2) }}</td>
                                    <td class="text-center">{{ $report->trans == 'CS' || $report->trans == 'AO' ? -$report->quantity_out : $report->quantity_in }}</td>
                                    <td class="text-end">{{ $report->trans == 'CS' || $report->trans == 'AO' ? '-'.number_format($report->carry, 2) : number_format($report->costs, 2) }}</td>
                                    @role('Super Admin|Admin|Product Manager')
                                    <td class="text-end pe-2">
                                        @if ( $report->trans == 'CS' || $report->trans == 'OB' || $report->trans == 'AI' || $report->trans == 'AO' )
                                        <span data-feather="alert-triangle" class="text-warning"></span>
                                        @else
                                        <a href="{{ route('inventories.show', $report->id) }}" rel="facebox" title="Edit or Delete">
                                            <i class="align-middle" data-feather="edit"></i>
                                        </a>
                                        @endif
                                    </td>
                                    @endrole
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="9" class="text-center">Record not found</td>
                                </tr>
                                @endforelse
                            </tbody>
                            @endif
                            @if( !empty($purchase_cost) )
                            <tbody>
                                <tr class="summary">
                                    <td colspan="7"><strong>Total Purchase</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($purchase_cost, 2) }}</strong></td>
                                    @role('Super Admin|Admin|Product Manager')
                                    <td></td>
                                    @endrole
                                </tr>
                            </tbody>
                            @endif
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<script src="{{ asset('assets/js/datatables.js') }}"></script>
<script>
    $(document).ready(function() {
        var dTable = $("#table-purchases tr");
        if (dTable.length > 2) {
            $("#table-purchases").DataTable({
                "pageLength": 25,
                responsive: false
            });
        }
    });
</script>
@endsection