@extends('layouts.main_admin')


@section('content')





    <div class="page-body">
        <div class="container-fluid">
            <div class="page-title">
                <div class="row">
                    <div class="col-6">
                        <h3>{{ $title }}</h3>
                    </div>
                    <div class="col-6">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item">@lang('site.dashboard')</li>

                            <li class="breadcrumb-item active">
                                @lang('site.places')
                                @endlang
                            </li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>


        <div class="container-fluid">
            <div class="row">
                <!-- HTML (DOM) sourced data  Starts-->
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-3">{{ $title }}({{ $count }})</h5>

                            {{-- {{dd($countries)}} --}}
                        </div>
                        <div class="bg-secondary-lighten card-header d-flex justify-content-between">
                            <h5>@lang('site.add') </h5>
                            <div class="text-end  group-btn-top">
                                <div class="form-group d-flex form-group justify-content-between">

                                    <a href="{{ route('dashboard.places.create') }}"
                                        class="btn btn-air-primary btn-pill btn-primary"><i class="fa fa-plus p-1"></i>
                                        @lang('site.add')</a>
                                </div>
                            </div>


                        </div>

                        <div class="container">

                            @if ($errors->any())
                                <div class="alert">
                                    <ul>
                                        @foreach ($errors->all() as $error)
                                            <li class="text-danger">*{{ $error }} </li>
                                        @endforeach
                                    </ul>
                                </div>
                            @endif
                            <form action="{{ route('dashboard.SearchplacesDashboard') }}" method="POST">
                                @csrf
                                <div class="row">
                                    <div class="col-2">
                                        <label class="form-label">@lang('site.country')</label>
                                        <select class="js-example-placeholder-multiple col-sm-12" id="countrySelect"
                                            name="country_id" required>
                                            <option selected disabled>@lang('site.country')</option>
                                            @foreach ($countries as $item)
                                                @if (app()->getLocale() == 'ar')
                                                    <option value="{{ $item->id }}">{{ $item->name_ar }}</option>
                                                @else
                                                    <option value="{{ $item->id }}">{{ $item->name_en }}</option>
                                                @endif
                                            @endforeach

                                        </select>
                                    </div>
                                    <div class="col-2">
                                        <label class="form-label">@lang('site.city')</label>
                                        <select class="js-example-placeholder-multiple col-sm-12" name="city_id"
                                            id="city_id" required>
                                            <option selected disabled>@lang('site.city')</option>
                                            {{-- @foreach ($cities as $citem)
                                                 <option value="{{ $citem->id }}">{{ $citem->name_ar }}</option>
                                            @endforeach --}}

                                        </select>
                                        {{-- <div id="cities-container"></div> --}}
                                    </div>


                                 

                                    <div class="col-2">
                                        <label class="form-label">@lang('site.category')</label>
                                        <select class="js-example-placeholder-multiple col-sm-12" name="category_id"
                                            id="category_id">
                                            <option selected disabled>@lang('site.category')</option>
                                            @foreach ($Category as $catitem)
                                                @if (app()->getLocale() == 'ar')
                                                    <option value="{{ $catitem->id }}">{{ $catitem->name_ar }}</option>
                                                @else
                                                    <option value="{{ $catitem->id }}">{{ $catitem->name_en }}</option>
                                                @endif
                                            @endforeach

                                        </select>
                                    </div>
                                    <div class="col-2">
                                        <label for="exampleInputEmail1" class="form-label">@lang('site.name')</label>
                                        <input type="text" class="form-control" id="exampleInputEmail1"
                                            aria-describedby="emailHelp" name="query" value="{{ old('query') }}">
                                    </div>
                                    <div class="col-2">
                                        <label for="exampleInputEmail1" class="form-label"></label>

                                        <button type="submit"
                                            class=" form-control btn btn-primary btn-lg rounded">@lang('site.search')</button>
                                    </div>
                                </div>
                            </form>

                        </div>

                        {{-- {{dd($places)}} --}}
                        @if ($places != null)
                            @if ($count > 0)
                                <div class="card-body">

                                    <div class="dt-ext table-responsive">




                                        <button class="btn btn-lg" id="exportButton"
                                            style="background-color: #f73164;color: white;"><i class="fa fa-download"></i>
                                            &nbsp;@lang('site.export') </button>
                                        <button class="btn btn-lg" id="printButton"
                                            style="background-color: #f73164;color: white;"><i class="fa fa-print"></i>
                                            &nbsp;@lang('site.print') </button>

                                        {{-- <script>
                                        const exportCSV = () => {
                                            const data = [ // Replace with your actual data
                                                ["Name", "Email", "City"],
                                                ["John Doe", "johndoe@example.com", "New York"],
                                                ["Jane Smith", "janesmith@example.com", "Los Angeles"],
                                            ];

                                            const csvContent = data.map(row => row.join(",")).join("\n");
                                            const blob = new Blob([csvContent], {
                                                type: 'text/csv;charset=utf-8'
                                            });
                                            const url = window.URL.createObjectURL(blob);

                                            const a = document.createElement('a');
                                            a.href = url;
                                            a.download = 'data.csv';
                                            a.click();

                                            window.URL.revokeObjectURL(url); // Revoke temporary URL
                                        };

                                        document.getElementById('export-csv').addEventListener('click', exportCSV);
                                    </script> --}}
                                        <table class="table table-bordered table-striped " id="myTable" style="text-align: center">
                                            <div class="row">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>@lang('site.name')</th>
                                                        <th>@lang('site.descrption_ar')</th>
                                                        <th>@lang('site.phone_one')</th>
                                                        <th>@lang('site.created_at')</th>
                                                        <th>@lang('site.action')</th>
                                                    </tr>
                                                </thead>

                                                <tbody>
                                                    @if (app()->getLocale() == 'ar')
                                                        @foreach ($places as $key => $item)
                                                            <tr>
                                                                <td>{{ $item->id }}</td>
                                                                <td class="col-1"><p style="margin-block: 30px; font-weight:700">{{ $item->name_ar }}</p></td>
                                                                <td class="col-6">{{ $item->descrption_ar }}</td>
                                                                <td class="col-1" ><p style="margin-block: 30px">{{ $item->phone_one }}</p></td>
                                                                <td class="col-2"><p style="margin-block:30px">{{ $item->created_at }}</p></td>
                                                                <td class="d-flex "  >
                                                                   <div class="a-one " style="margin-inline: 1.5rem; margin-block:25px;">
                                                                    <a
                                                                    href="{{ url('dashboard/places/' . $item->id . '/edit') }}">
                                                                    <i class="fa fa-edit"
                                                                        style="color: #7366FF;font-size: 23px; "></i>
                                                                    </a>
                                                                   </div>


                                                                <div class="a-two" style="margin-inline: 1.5rem;margin-block:25px">
                                                                    <a href="{{ url('dashboard/places/' . $item->id) }}"><i
                                                                        class="fa fa-eye"
                                                                        style="color: #7366FF;font-size: 23px;"></i></a>
                                                                </div>

                                                               <div class="a-three" style="margin-inline: 1.5rem;margin-block:25px">
                                                                <a
                                                                href="{{ url('dashboard/searchplacesdelete/' . $item->id) }}"><i
                                                                    class="fa fa-trash"
                                                                    style="color: #7366FF;font-size: 23px;"></i></a>
                                                               </div>
                                                                </td>
                                                            </tr>
                                                        @endforeach
                                                    @else
                                                        @foreach ($places as $key => $item)
                                                            <tr>
                                                                <td class="col-1"><p style="margin-block: 30px; font-weight:700">{{ $item->name_en }}</p></td>
                                                                <td class="col-6">{{ $item->descrption_en }}</td>
                                                                <td class="col-1" ><p style="margin-block: 30px">{{ $item->phone_one }}</p></td>
                                                                <td class="col-2"><p style="margin-block:30px">{{ $item->created_at }}</p></td>
                                                                <td class="d-flex col-2 "  >
                                                                    <div class="a-one " style="margin-inline: 1.5rem; margin-block:25px">
                                                                        <a
                                                                        href="{{ url('dashboard/places/' . $item->id . '/edit') }}">
                                                                        <i class="fa fa-edit"
                                                                            style="color: #7366FF;font-size: 23px; "></i>
                                                                        </a>
                                                                    </div>
                                                                    
                                                                    <div class="a-two" style="margin-inline: 1.5rem;margin-block:25px">
                                                                        <a href="{{ url('dashboard/places/' . $item->id) }}"><i
                                                                            class="fa fa-eye"
                                                                            style="color: #7366FF;font-size: 23px;"></i></a>
                                                                    </div>
    
                                                                   <div class="a-three" style="margin-inline: 1.5rem;margin-block:25px">
                                                                        <a
                                                                        href="{{ url('dashboard/searchplacesdelete/' . $item->id) }}"><i
                                                                            class="fa fa-trash"
                                                                            style="color: #7366FF;font-size: 23px;"></i></a>
                                                                   </div>
                                                                </td>
                                                            </tr>
                                                        @endforeach
                                                    @endif

                                                </tbody>
                                            </div>
                                        </table>
                                        <script>
                                            $(document).ready(function() {
                                                $('#printButton').click(function() {
                                                    var printableDiv = $('#myTable');
                                                    var newWin = window.open('', '',
                                                        'width=800,height=600'); // Optional: Set window size for printing
                                                    newWin.document.write(printableDiv.html());
                                                    newWin.document.close();
                                                    newWin.focus();
                                                    newWin.print();
                                                    newWin.close(); // Optional: Close the new window after printing
                                                });
                                            });
                                        </script>

                                        <script>
                                            document.getElementById('exportButton').addEventListener('click', function() {
                                                var table = document.getElementById('myTable');
                                                var csvContent = '';

                                                // Get header row data
                                                var headerRow = table.rows[0];
                                                for (var i = 0; i < headerRow.cells.length; i++) {
                                                    csvContent += headerRow.cells[i].textContent + ',';
                                                }
                                                csvContent = csvContent.slice(0, -1) + '\n'; // Remove trailing comma from header

                                                // Get data from remaining rows
                                                for (var i = 1; i < table.rows.length; i++) {
                                                    var row = table.rows[i];
                                                    for (var j = 0; j < row.cells.length; j++) {
                                                        var cellData = row.cells[j].textContent;
                                                        // Escape commas and newlines within cell data (optional)
                                                        cellData = cellData.replace(/"/g, '""'); // Escape double quotes
                                                        cellData = cellData.replace(/\r?\n|\r/g, ' '); // Replace newlines with spaces
                                                        csvContent += '"' + cellData + '",';
                                                    }
                                                    csvContent = csvContent.slice(0, -1) + '\n'; // Remove trailing comma from each row
                                                }

                                                // Create a Blob object with the CSV content
                                                var blob = new Blob([csvContent], {
                                                    type: 'text/csv;charset=utf-8'
                                                });

                                                // Create a downloadable link and trigger click
                                                var link = document.createElement('a');
                                                link.href = URL.createObjectURL(blob);
                                                link.download = 'saeeh.csv';
                                                link.click();

                                                // Clean up the temporary link (optional)
                                                setTimeout(function() {
                                                    URL.revokeObjectURL(link.href);
                                                }, 1000); // Delay to allow download to complete
                                            });
                                        </script>
                                    </div>
                                </div>
                                <link rel="stylesheet"
                                    href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css"
                                    integrity="sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65"
                                    crossorigin="anonymous">

                                    <br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function request() in /home/saeeh/public_html/resources/views/dashboard/places/index.blade.php:321
Stack trace:
#0 {main}
  thrown in <b>/home/saeeh/public_html/resources/views/dashboard/places/index.blade.php</b> on line <b>321</b><br />