@extends('admin.layout.master')
@section('title','DATABASE')
@section ('content') 
    <style> 
        .table th,
        .table td {
            padding: 0rem;
            padding-left: 0.35rem;
            /* padding-right: 0.35rem;
            padding-top: 0.35rem;
            padding-bottom: 0.35rem; */
        }
        .table th {
            background: #ab3535;
            padding: 5px !important;
            color: white !important;
        }
        .custom-td {
            white-space:pre-wrap;
            word-wrap:break-word;
        }
    </style>
    <div class="card sina-card">
        <div class="card-header card-header-s d-flex flex-wrap align-items-center">
            <h4 class="col-6 pl-0">Database List</h4>
            <div  class="col-6 d-flex justify-content-end">
                <a href="{{url()->to('/backup')}}" class="btn-sina-title-add d-flex align-items-center" type="button" name="button">
                    <div class="col pl-0 pr-2">
                        <i class="fas fa-plus-circle"></i>
                    </div>
                    <div class=""> Create Backup </div>
                </a>
            </div>
        </div>
        <div class="card-body">
            {{-- <form method="post" name="filter_form" id="filter_form">
                @csrf 
                <div class="d-flex flex-wrap justify-content-center">
                    <div class="col-md-2 col-12 flex-wrap pr-0 mb-2">
                        <label for="tran_type">Type</label>
                        <select class="select2 form-control" style="width: 100%" name="tran_type" id="tran_type">
                            <option value="5">Stock In</option>
                            <option value="6">Stock out</option>
                            <option value="7">Damage</option>
                            <option value="16">IN/OUT</option>
                        </select>
                    </div> 
                    <div class="col-md-2 col-12 flex-wrap pr-0 mb-2">
                        <label for="inv_no">Invoice No</label>
                        <input type="text" class="form-control" name="inv_no" id="inv_no">
                    </div>
                    <div class="col-md-2 col-12 flex-wrap pr-0 mb-2">
                        <label for="date_from">Date From</label>
                        <input type="text" class="form-control date_picker" name="date_from" id="date_from">
                    </div>
                    <div class="col-md-2 col-12 flex-wrap pr-0 ">
                        <label for="date_to">Date To</label>
                        <input type="text" class="form-control date_picker" name="date_to" id="date_to">
                    </div>
                    <div class="col-md-1 col-1 flex-wrap pr-0 text-center mb-2"><br>
                        <button class="btn btn-sm btn-outline-info font-weight-bold d-flex" name="filter" id="filter">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-filter pt-1" viewBox="0 0 16 16">
                                <path d="M6 10.5a.5.5 0 0 1 .5-.5h3a.5.5 0 0 1 0 1h-3a.5.5 0 0 1-.5-.5zm-2-3a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7a.5.5 0 0 1-.5-.5zm-2-3a.5.5 0 0 1 .5-.5h11a.5.5 0 0 1 0 1h-11a.5.5 0 0 1-.5-.5z"/>
                            </svg>&nbsp;Filter</button>
                    </div>
                </div> 
            </form> --}}
            <hr>
            <div class="table-responsive"  id="div_tbl"> 
                <table class="table table-striped" id="tbl">
                    <thead>
                        <tr>
                            <th>SL.</th>    
                            <th>Date</th>    
                            <th>Action</th>    
                        </tr>
                    </thead>   
                    <tbody>
                        @forelse ($data as $i => $item)
                            <tr>
                                <td>{{ $i+1 }}</td>
                                <td>{{ date('d-m-Y h:i A', strtotime($item->date)) }}</td>
                                <td> 
                                    <div class="d-flex">
                                        <a href="{{ asset('storage/'.$item->link) }}" class="btn btn-sm btn-info" download> Download </a> 
                                        {{-- <form action="{{ route('db.destroy',$item->id) }}" > --}}
                                            <a href="{{ route('db.destroy',$item->id) }}" class="btn btn-sm btn-danger"> Delete </a>
                                        {{-- </form> --}}
                                    </div>
                                </td>
                            </tr>                            
                        @empty
                            
                        @endforelse
                        
                    </tbody> 
                </table>    
            </div> 
        </div>
    </div>
            
@endsection

@section('script') 
    <script>
        $(document).ready(function(){
            $('#tbl').dataTable();
        })
    </script>
@endsection