| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220 |
- <div class="table-responsive">
- <div class="table-buttons py-2 bg-primary rounded-start d-flex flex-column ">
- <button type="button" class="btn btn-sm text-white" data-bs-toggle="modal" data-bs-target="#table_{{ $id }}_modal_search">
- <i class="bi bi-search"></i>
- </button>
- <button type="button" class="btn btn-sm text-white " data-bs-toggle="modal" data-bs-target="#table_{{ $id }}_modal_filters">
- <i class="bi bi-funnel-fill"></i>
- </button>
- <button type="button" class="btn btn-sm text-white " data-bs-toggle="modal" data-bs-target="#table_{{ $id }}_modal_settings">
- <i class="bi bi-gear-fill"></i>
- </button>
- </div>
- <table class="table" id="tbl" data-table-name="{{ $id }}" style="display: none;">
- <thead>
- <tr>
- @foreach($header as $headerName => $headerTitle)
- <th scope="col" class="bg-primary-subtle column_{{ $headerName }}">
- <span class="cursor-pointer sort-by-column" data-name="{{ $headerName }}">
- {{ $headerTitle }}
- @if(str_starts_with($headerName, $sortBy))
- @if($orderBy === 'asc')
- <i class="bi bi-arrow-up"></i>
- @else
- <i class="bi bi-arrow-down"></i>
- @endif
- @endif
- @if(isset(request()->filters[$headerName]) ||
- isset(request()->filters[str_replace('_txt', '', $headerName) . '_from']) ||
- isset(request()->filters[str_replace('_txt', '', $headerName) . '_to'])
- )
- <i class="bi bi-funnel"></i>
- @endif
- </span>
- </th>
- @endforeach
- </tr>
- </thead>
- <tbody>
- @foreach($products as $product)
- <tr>
- @foreach($header as $headerName => $headerTitle)
- <td class="column_{{$headerName}}">{!! $product->$headerName !!}</td>
- @endforeach
- </tr>
- @endforeach
- </tbody>
- </table>
- </div>
- <!-- Модальное окно настроек таблицы -->
- <div class="modal fade" id="table_{{ $id }}_modal_settings" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
- <div class="modal-dialog modal-fullscreen-sm-down">
- <div class="modal-content">
- <div class="modal-header">
- <h1 class="modal-title fs-5" id="exampleModalLabel">Выбор отображаемых колонок</h1>
- <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Закрыть"></button>
- </div>
- <div class="modal-body">
- @foreach($header as $headerName => $headerTitle)
- <div>
- <label class="me-3"><input type="checkbox" checked="checked" data-name="{{ $headerName }}" class="toggle-column checkbox-{{ $headerName }}"> {{ $headerTitle }}</label>
- </div>
- @endforeach
- </div>
- <div class="modal-footer">
- <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Закрыть</button>
- </div>
- </div>
- </div>
- </div>
- <!-- Модальное окно фильтров -->
- <div class="modal fade" id="table_{{ $id }}_modal_filters" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
- <div class="modal-dialog modal-fullscreen-sm-down modal-lg">
- <div class="modal-content">
- <div class="modal-header">
- <h1 class="modal-title fs-5" id="exampleModalLabel">Фильтры по колонкам таблицы</h1>
- <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Закрыть"></button>
- </div>
- <div class="modal-body">
- <form class="filters">
- @foreach($filters as $filterName => $filter)
- @php array_unshift($filter['values'], '') @endphp
- @include('partials.select', [
- 'name' => 'filters[' . $filterName . ']',
- 'title' => $filter['title'],
- 'options' => $filter['values'],
- 'value' => request()->filters[$filterName] ?? '',
- 'key_as_val' => true
- ])
- @endforeach
- @foreach($ranges as $rangeName => $range)
- @include('partials.input', [
- 'name' => 'filters[' . $rangeName . '_from]',
- 'type' => 'number',
- 'title' => $range['title'] . ' с:',
- 'min' => $range['min'],
- 'max' => $range['max'],
- 'value' => request()->filters[$rangeName . '_from'] ?? '', // $range['min']
- ])
- @include('partials.input', [
- 'name' => 'filters[' . $rangeName . '_to]',
- 'type' => 'number',
- 'title' => ' по:',
- 'min' => $range['min'],
- 'max' => $range['max'],
- 'value' => request()->filters[$rangeName . '_to'] ?? '', // $range['max']
- ])
- @endforeach
- @foreach($dates as $rangeName => $range)
- @include('partials.input', [
- 'name' => 'filters[' . $rangeName . '_from]',
- 'type' => 'date',
- 'title' => $range['title'] . ' с:',
- 'min' => $range['min'],
- 'max' => $range['max'],
- 'value' => request()->filters[$rangeName . '_from'] ?? '',
- ])
- @include('partials.input', [
- 'name' => 'filters[' . $rangeName . '_to]',
- 'type' => 'date',
- 'title' => $range['title'] . ' по:',
- 'min' => $range['min'],
- 'max' => $range['max'],
- 'value' => request()->filters[$rangeName . '_to'] ?? '',
- ])
- @endforeach
- </form>
- </div>
- <div class="modal-footer">
- <button type="button" class="btn btn-primary accept-filters" data-bs-dismiss="modal">Применить</button>
- <button type="button" class="btn btn-outline-secondary reset-filters" data-bs-dismiss="modal">Сбросить</button>
- </div>
- </div>
- </div>
- </div>
- @dump($filters, $ranges, $dates)
- @push('scripts')
- <script type="module">
- // on page load set column visible
- let tableName = $('#tbl').attr('data-table-name');
- let tables = JSON.parse(localStorage.getItem('table_'+tableName));
- // on first load create tables object
- if(!tables) { tables = {}; }
- $.each(tables, function (colName, colStatus) {
- if(!colStatus) {
- $('.checkbox-'+colName).attr('checked', false);
- $('.column_'+colName).hide();
- }
- });
- $('.table').fadeIn();
- $('.toggle-column').on('change', function () {
- let columnName = $(this).attr('data-name');
- let columnStatus = $(this).is(':checked');
- // save column status
- tables[columnName] = columnStatus;
- localStorage.setItem('table_'+tableName, JSON.stringify(tables));
- // show or hide column
- if(columnStatus) {
- $('.column_'+columnName).show('fast');
- } else {
- $('.column_'+columnName).hide('fast');
- }
- });
- $('.sort-by-column').on('click', function () {
- let columnName = $(this).attr('data-name');
- let currentUrl = new URL(document.location.href);
- let currentColumnName = currentUrl.searchParams.get('sortBy');
- currentUrl.searchParams.set('sortBy', columnName);
- if((currentColumnName !== columnName) || (currentUrl.searchParams.has('order'))) {
- currentUrl.searchParams.delete('order');
- } else {
- currentUrl.searchParams.set('order', 'desc');
- }
- document.location.href = currentUrl.href;
- });
- $('.accept-filters').on('click', function () {
- let filters = $('.filters').serializeArray();
- let currentUrl = new URL(document.location.href);
- $.each(filters, function (id, filter) {
- if(filter.value !== '') {
- currentUrl.searchParams.set(filter.name, filter.value);
- } else {
- currentUrl.searchParams.delete(filter.name);
- }
- });
- document.location.href = currentUrl.href;
- });
- $('.reset-filters').on('click', function () {
- let filters = $('.filters').serializeArray();
- let currentUrl = new URL(document.location.href);
- $.each(filters, function (id, filter) {
- currentUrl.searchParams.delete(filter.name);
- });
- document.location.href = currentUrl.href;
- });
- </script>
- @endpush
|