@extends('layouts.app')
@section('content')
<section class="content">
    <div class="container-fluid">

        <div class="px-sm-4">

            <div class="row mt-2 mt-sm-3">
                <div class="col-md-5 col-10">
                    <div class="top-head">
                        <h1>Milk Supply</h1>
                        <nav aria-label="breadcrumb">
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item"><a href="#">Home</a></li>
                                <li class="breadcrumb-item active" aria-current="page"> Milk Supply</li>
                            </ol>
                        </nav>
                    </div>
                </div>
                <div class="col-md-7 col-2 text-right">
                    <div class="d-flex justify-content-end">
                        <div class="top-search-bar d-sm-block d-none mr-2">
                            <form class="search-form" role="search">
                                <div class="form-group pull-right" id="searchnew">
                                    <input type="text" class="form-control" placeholder="Search by...">
                                    <button type="submit" class="form-control form-control-submit">Submit</button>
                                    <span class="search-label"><img src="{{asset('assets/img/search.svg')}}" alt="/"></span>
                                </div>
                            </form>
                        </div>
                        <button class="btn btn-primary mr-2" data-toggle="modal" data-target="#uploadModal"><i class="fa fa-upload text-white mr-2" aria-hidden="true"></i>Upload Milk Supply</button>
                        <!-- <button class="btn btn-primary mr-2"  type = "button" onclick = "downloadFile()"> Download Sample file </button> -->
                        <a href="{{ url('/download-sample-file') }}" class="btn btn-info mr-2"><i class="fa fa-download text-white mr-2" aria-hidden="true"></i>Download Sample file</a>

                    </div>
                </div>
            </div>

          
            <!-- Display Success Flash Message -->
            @if(session('success'))
            <div class="alert alert-success">
                {{ session('success') }}
            </div>
            @endif
            @if(session('error'))
            <div id="error-message" class="alert alert-warning">
                {{ session('error') }}
            </div>
            @endif

            <div class="row mt-2 mt-sm-4">
                <div class="col-md-12">
                    <div class="card financials-card p-2">
                        <div class="table-responsive mt-2">
                            <table class="table dairy-table mb-0">
                                <thead>
                                    <tr>
                                        <th>DATE</th>
                                        <th>SUPPLIER ID </th>
                                        <th>SUPPLIER TYPE </th>
                                        <th>NAME</th>
                                        <th>Address</th>
                                        <th>Milk supply</th>
                                        <th>milk value</th>
                                        <th>milk price</th>
                                        <!-- <th>STATUS</th> -->
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($farmerMilkSupply as $milkSupply)
                                    @php
                                    $mcc=\DB::table('milk_collection_centers')->where('supplier_id',$milkSupply->supplier_id)->first();
                                    $farmerMaster = \DB::table('farmer_masters')
                                    ->join('addresses', 'farmer_masters.id', '=', 'addresses.addressable_id')
                                    ->where('farmer_masters.supplier_id', $milkSupply->supplier_id)
                                    ->first();
                                    if($mcc)
                                    {
                                    $type=@$mcc->type;
                                    $name=@$mcc->name;
                                    $address=@$mcc->address->address;
                                    }
                                    else{

                                    $name=@$farmerMaster->name;
                                    $type=\DB::table('users')->where('id',@$farmerMaster->user_id)->value('user_type');
                                    $address=@$farmerMaster->address;
                                    }

                                    @endphp
                                    <tr>
                                        <td>{{Date('d/m/Y',strtotime($milkSupply->date))}}</td>
                                        <td>{{$milkSupply->supplier_id}}</td>
                                        <td>{{$type}}</td>
                                        <td>{{$name}}</td>
                                        <td>{{$address }}</td>
                                        <td>{{$milkSupply->milk_supplied}}</td>
                                        <td> {{$milkSupply->milk_value}} </td>
                                        <td>{{$milkSupply->milk_price}} </td>
                                    </tr>
                                    @endforeach

                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            {{ $farmerMilkSupply->appends(request()->input())->links('partials.pagination') }}

            
        </div>
    </div>

    <div class="modal fade" id="uploadModal" tabindex="-1" aria-labelledby="uploadModalLabel" aria-hidden="true">
        <div class="modal-dialog">

            <div class="modal-content">

               
                <div class="modal-header">

                    <h5 class="modal-title" id="uploadModalLabel">Upload Excel Sheet</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <form id="uploadForm" action="{{ route('upload.excel') }}" method="POST" enctype="multipart/form-data">
                        @csrf
                        <div class="form-group">
                            <input type="file" class="form-control-file" required id="excelFile" name="excelFile">
                        </div>
                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                    <button type="button" class="btn btn-primary" onclick="uploadFile()">Upload</button>
                </div>
            </div>
        </div>
    </div>
</section>

@endsection

@section('scripts')
<script>
    function uploadFile() {

        var fileInput = document.getElementById('excelFile');
        var file = fileInput.files[0];
        if (file) {
            var fileName = file.name;
            var fileExtension = fileName.split('.').pop();
            // console.log(file,fileExtension, typeof(fileExtension));
            
            var fileSize = file.size; // Get file size in bytes
            // console.log(fileSize);
            // return false;
            var maxSize = 1024 * 1024 * 10; // 10MB in bytes
            // Check if file size exceeds the maximum allowed size
            if (fileSize > maxSize) {
                Swal.fire({
                    type: 'error',
                    title: 'File size exceeds!',
                    text: 'Please upload file size maximum 10 MB!',
                });
                return;
            }
            if(fileExtension === 'xlsx' || fileExtension === 'xls'){
                // If file size is within the limit, submit the form
                $('#uploadForm').submit();
            }else{
                Swal.fire({
                    type: 'error',
                    title: 'Invalid File Type',
                    text: 'Please upload files with extensions xlsx, or xls.',
                });
                return;
            }
            
        } else {
            alert('Please select a file.');
        }
        setTimeout(() => {
            window.location.reload();
        }, 5000);

        setTimeout(function() {
            document.getElementById('error-message').style.display = 'none'; // Hide the error message
        }, 5000); // 5000 milliseconds = 5 seconds

    }
</script>



@endsection