@extends('layouts.app')
@section('main-content')
<style type="text/css">
    .bottom-aligner {
        display: inline-block;
        height: 100%;
        vertical-align: bottom;
        width: 3px;
        /* background: #f2f554; */
    }

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

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

    td,
    th {
        font-size: 0.9em;
    }
</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">Sales Report</li>
        </ol>
    </nav>
    <h1 class="h3 mb-3"><strong>Sales</strong> Report</h1>

    <div class="row">
        <div class="col-12">
            <div class="card flex-fill">
                <div class="card-header d-flex justify-content-between">
                    <h5 class="card-title mb-0">Sales 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.salesreports') }}" 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-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 class="pt-2">
                                            <span class="d-flex ms-4"><input type="checkbox" name="" value="1" id="chkbox">
                                                <font class="ms-1 text-nowrap">Calculation</font>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                    <div class="table-responsive pt-3">
                        @if(!empty($salesReports))
                        <table class="table table-striped">
                            <thead class="text-nowrap">
                                <th>#</th>
                                <th>INVOICE</th>
                                <th>DATE</th>
                                <th class="text-end text-nowrap">REVENUE</th>
                                <th class="text-end text-nowrap">PRD COST</th>
                                <th class="text-end text-nowrap">SERVICES</th>
                                <th class="text-end text-nowrap">FREON</th>
                                <th class="text-end text-nowrap">FLUSHING</th>
                                <th class="text-end text-nowrap">PROFIT</th>
                                <th class="text-end text-nowrap">DISCOUNT</th>
                                <th class="text-end text-nowrap">SALES</th>
                            </thead>
                            <tbody>
                                @forelse($salesReports as $report)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td><a href="{{ route('invoices.show', $report->invoice_no) }}" target="_parent" rel="noopener noreferrer">INV{{ str_pad($report->invoice_no, 5, '0', STR_PAD_LEFT) }}</a></td>
                                    <td>{{ $report->invoice_date }}</td>
                                    <td class="text-end">{{ number_format($report->grand_total , 2) }}</td>
                                    <td class="text-end">{{ number_format($report->cost_price, 2) }}</td>
                                    <td class="text-end">{{ number_format($report->labour, 2) }}</td>
                                    <td class="text-end">{{ number_format($report->var_rate, 2) }}</td>
                                    <td class="text-end">{{ number_format($report->flushing, 2) }}</td>
                                    <td class="text-end">{{ number_format($report->earning - $report->discount, 2) }}</td>
                                    <td class="text-end">{{ number_format($report->discount, 2) }}</td>
                                    <td class="text-end">{{ number_format($report->sales - $report->discount, 2) }}</td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="11" class="text-center">Record not found</td>
                                </tr>
                                @endforelse
                                @if(count($salesReports) > 0)
                                <tr>
                                    <th>#</th>
                                    <th></th>
                                    <th></th>
                                    <th class="text-end text-nowrap">REVENUE</th>
                                    <th class="text-end text-nowrap">PRD COST</th>
                                    <th class="text-end text-nowrap">SERVICES</th>
                                    <th class="text-end text-nowrap">FREON</th>
                                    <th class="text-end text-nowrap">FLUSHING</th>
                                    <th class="text-end text-nowrap">PROFIT</th>
                                    <th class="text-end text-nowrap">DISCOUNT</th>
                                    <th class="text-end text-nowrap">SALES</th>
                                </tr>
                                <tr>
                                    <td colspan="3"><strong>GRAND TOTAL</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($grand_total, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($itemCost, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($labour, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($var_rate, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($flushing, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($earns, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($discount, 2) }}</strong></td>
                                    <td class="text-end text-nowrap"><strong>RM{{ number_format($sales, 2) }}</strong></td>
                                </tr>
                                @endif
                            </tbody>
                        </table>
                        <span id="calc"></span>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<script type="text/javascript">
    $(document).ready(function() {
        $('#chkbox').on('click', function() {
            var checkBox = $('#chkbox');
            if (checkBox.prop('checked')) {
                $lagend = 'Remark:';
                $sales = 'SALES = (PRODUCT SALES)';
                $earning = 'PROFIT = (SALES - PRD COST)';
                $('#calc').html($lagend + '<br />' + $sales + '<br />' + $earning);
            } else {
                $('#calc').html('');
            }
        });
    });
</script>
@endsection