@extends('admin.layouts.app')
@section('title', 'Product Wise Sale')
@push('styles')
@endpush
@section('container')
    <!-- Page-Title -->
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <div class="float-end">

                </div>
                <h4 class="page-title">Product Wise Sale</h4>
            </div>
            <!--end page-title-box-->
        </div>
        <!--end col-->
    </div>
    <!-- end page title end breadcrumb -->

    <div class="row">
        @if (session('success'))
            <div class="alert alert-info">
                {{ session('success') }}
            </div>
        @endif
        @if (session('error'))
            <div class="alert alert-danger">
                {{ session('error') }}
            </div>
        @endif
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <form action="">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="mb-3 row">
                                    <label class="col-sm-4 col-form-label text-end">Product</label>
                                    <div class="col-sm-8">
                                        <select name="product" id="product" class="form-control select2">
                                            <option value="0">All</option>
                                            @foreach ($products as $product)
                                                <option {{ request()->product == $product->id ? 'selected' : '' }}
                                                    value="{{ $product->id }}">{{ $product->name }}</option>
                                            @endforeach

                                        </select>
                                        @error('product')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>

                            </div>
                            <div class="col-md-3">
                                <div class="mb-3 row">
                                    <label class="col-sm-4 col-form-label text-end">Start Date</label>
                                    <div class="col-sm-8">
                                        <input type="date" name="start_date" id="start_date" value="{{ old('start_date', request()->start_date??date('Y-m-d')) }}" class="form-control">
                                        @error('start_date')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="mb-3 row">
                                    <label class="col-sm-4 col-form-label text-end">End Date</label>
                                    <div class="col-sm-8">
                                        <input type="date" name="end_date" id="end_date"
                                            value="{{ old('end_date', request()->end_date??date('Y-m-d')) }}" class="form-control">
                                        @error('end_date')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                            <div class="col-2">
                                <div class="text-end">
                                    <button class="btn btn-primary" type="submit">Search</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <!--end card-header-->
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header with-border">
                                <button class="pull-right btn btn-primary" onclick="getprint('prinarea')">Print</button>
                            </div>
                        </div>
                    </div>
                </div>
                <div id="prinarea">
                    @if(count($stocks) > 0)
                        <div class="card-header with-border text-center">
                            <h1 class="card-title" style="font-size: 25px;">{{ config('app.name') }}</h1>
                            <p style="font-size: 15px;margin: 0;">{{ config('app.address') }}</p>
                            <p style="font-size: 15px;">Product: {{ $productName }}</p>
                        </div>
                        <h4 class="text-end">Date: {{ date('d-m-Y',strtotime(request('start_date'))) }} to {{ date('d-m-Y',strtotime(request('end_date'))) }}</h4>
                    @endif
                    @if(count($stocks) > 0)
                        <table class="table table-bordered">
                            <tr>
                                <th>SL.</th>
                                <th>Product Type</th>
                                <th>Product Sub Type</th>
                                <th>Product</th>
                                <th>Unit</th>
                                <th>InQty</th>
                                <th>OutQty</th>
                                <th class="text-end">NetAmount</th>
                            </tr>
                            <tbody>
                                @php
                                    $total_stock_out = 0;
                                @endphp
                                @foreach($stocks as $index => $stock)
                                    @php
                                        $unit_id = \App\Models\Product::find($stock->product_id)->unit_id??0;
                                        $unit = \App\Models\Unit::find($unit_id);
                                        $total_stock_out += $stock->total_stock;
                                    @endphp
                                    <tr>
                                        <td>{{ $index+1 }}</td>
                                        <td>{{ $stock->product_category_name }}</td>
                                        <td>{{ $stock->product_sub_category_name }}</td>
                                        <td>{{ $stock->product_name }}</td>
                                        <td>{{ $unit->name }}</td>
                                        <td>0.00</td>
                                        <td>{{ number_format($stock->total_stock,2) }}</td>
                                        <td class="text-end">{{ number_format($stock->total_amount,2) }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th colspan="5" class="text-end">Total</th>
                                    <th>0.00</th>
                                    <th>{{ number_format($total_stock_out,2) }}</th>
                                    <th class="text-end">{{ number_format($stocks->sum('total_amount'),2) }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    @endif
                </div>
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div> <!-- end col -->


    </div> <!-- end row -->
@endsection


@push('scripts')
    <script>
        var APP_URL = '{!! url()->full()  !!}';
        function getprint(print) {

            $('body').html($('#'+print).html());
            window.print();
            window.location.replace(APP_URL)
        }
        $(function () {
            $('.select2').select2();
        });
    </script>
@endpush