@extends('portal.layout.app')
<link rel="stylesheet" href="{{ URL::asset('assets/css/global.css') }}">
<link rel="stylesheet" href="{{ URL::asset('assets/css/input.css') }}">
<link rel="stylesheet" href="{{ URL::asset('assets/plugins/bootstrap/css/bootstrap.min.css') }}">
@section('content')
<style>
    ::placeholder {
         color: #3080EA !important;
         opacity: 1 !important;
         font-size: 11px Roboto;
     }
    .search_btn {
        margin-right: -8px;
        margin-left: 3px;
    }
    .table_dropdown {
        margin-left: 4px;
    }
    .datepicker {
        left: 53% !important;
        position: absolute !important;
        z-index: 9999;
    }
    .datepicker_size {
        padding: 9px 10px;
    }
    ::placeholder {
      color: blue;
    }
    /*Allign columns and rows of table*/
    .table tr th, .table tr td {
        width: 119px !important;
        padding: 7px 15px;
    }
    .table table tr {
        display: table;
        width: 1208px !important;
        box-sizing: border-box;
    }
    .table table thead {
        display: table;
        width: 100%;
    }
    .table table tbody {
        display: block;
        max-height: 550px;
        overflow-y: auto;
        width: 1208px;
        overflow-x: hidden !important;
    }
     table:first-child td:first-child ,table:first-child th:first-child {
        padding-left: 10px !important;
    }
</style>
<div class="breadcrum">
    HR Services / Travel / <span class="text-primary">Travel Applications</span>
</div>
@php
    $data=(object)$data;
    $data->data=(object)$data->data;
@endphp
<section class="expense">
    <div class="row">
        <div class="col-md-12">
            <div class="float-right">
                <span class="travel_report_download font_weight_bold">[&nbsp;Download</span>
                <a href="#" class="travel_report_download excel_travel" data-key="pdf" >PDF</a>
                <span class="travel_report_download">/</span>
                <a href="" class="excel_travel" data-key="csv" >XLS</a>
                <span class="travel_report_download font_weight_bold">&nbsp;]</span>
            </div>
        </div>
        <div class="container-fluid">
            <div class="expense_header reason_box_width margin_left_one">
                <div class="expense_table">
                    <div class="row">
                        <div class="col-md-12">
                            <div class="expense_table_hader">
                                <div class="row">
                                    <div class="col-md-8">
                                        <div class="header_left">
                                            Travel Report
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <table class="float-right" style="margin-top:-3px;">
                                            <tbody>
                                                <tr>
                                                    <td>
                                                        <div class="dropdown">
                                                          <button class="dropdown_custom table_dropdown common_dropdown_properties countries_select" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                            <span style="
                                                                display: inline-block;
                                                                width: 73%;
                                                                margin-left: 0px !important;
                                                                text-overflow: ellipsis;
                                                                white-space: nowrap;
                                                                overflow: hidden;
                                                            ">Region</span>
                                                            <span style="margin-left: 18px !important;margin-top: 3px;position: fixed;">
                                                                <svg xmlns="http://www.w3.org/2000/svg" width="10" height="6" viewBox="0 0 10 6">
                                                                  <path id="Down_Arrow" data-name="Down Arrow" d="M5,0l5,6H0Z" transform="translate(10 6) rotate(180)" fill="#343434"/>
                                                                </svg>
                                                            </span>
                                                          </button>
                                                          <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                                <a class="dropdown-item dropdown_option_custom" key-value="-1">All</a>
                                                                @foreach($countries as $key =>$value)
                                                                    @php
                                                                        $value=(object)$value;
                                                                    @endphp
                                                                <a class="dropdown-item dropdown_option_custom" key-value="{{$value->id}}">{{$value->name}}</a>
                                                                @endforeach()
                                                          </div>
                                                        </div>
                                                        <!-- <div class="main_dropdown_div padding_four_right">
                                                            <select class="table_dropdown common_dropdown_properties countries_select">
                                                                <option value="-1">All Region</option>
                                                                @foreach($countries as $key =>$value)
                                                                    @php
                                                                        $value=(object)$value;
                                                                    @endphp
                                                                    <option value="{{$value->id}}">{{$value->name}}</option>
                                                                @endforeach()
                                                            </select>
                                                        </div> -->
                                                    </td>
                                                    <td>
                                                        <div class="dropdown">
                                                          <button class="dropdown_custom table_dropdown common_dropdown_properties travel_type" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                            <span style="
                                                                display: inline-block;
                                                                width: 73%;
                                                                margin-left: 0px !important;
                                                                text-overflow: ellipsis;
                                                                white-space: nowrap;
                                                                overflow: hidden;
                                                            ">Status</span>
                                                            <span style="margin-left: 18px !important;margin-top: 3px;position: fixed;">
                                                                <svg xmlns="http://www.w3.org/2000/svg" width="10" height="6" viewBox="0 0 10 6">
                                                                  <path id="Down_Arrow" data-name="Down Arrow" d="M5,0l5,6H0Z" transform="translate(10 6) rotate(180)" fill="#343434"/>
                                                                </svg>
                                                            </span>
                                                          </button>
                                                          <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                                <a class="dropdown-item dropdown_option_custom" key-value="-1">All</a>
                                                                @foreach($types as $key =>$value)
                                                                    @php
                                                                        $value=(object)$value;
                                                                    @endphp
                                                                <a class="dropdown-item dropdown_option_custom" key-value="{{$value->id}}">{{$value->description}}</a>
                                                                @endforeach()
                                                          </div>
                                                        </div>

                                                       <!--  <div class="main_dropdown_div padding-right">
                                                            <select class="table_dropdown common_dropdown_properties travel_type">
                                                                <option value="">Travel Type</option>
                                                                @foreach($types as $key =>$value)
                                                                    @php
                                                                        $value=(object)$value;
                                                                    @endphp
                                                                    <option value="{{$value->id}}">{{$value->description}}</option>
                                                                @endforeach()
                                                                <option value="-1">All</option>
                                                            </select>
                                                        </div> -->
                                                    </td>
                                                    <td>
                                                        <div class="main_dropdown_div padding-right">
                                                            <input type="text" class="start_date table_dropdown common_dropdown_properties dateselect datepicker_size" placeholder="From Date"/>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <div class="main_dropdown_div padding-right">
                                                            <input type="text" class="end_date table_dropdown common_dropdown_properties dateselect datepicker_size" placeholder="To Date"/>
                                                        </div>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <div class="main_dropdown_div">
                                                            <button class="search_btn align_search_btn">Search</button>
                                                        </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <div class="table" id="sorting_table">
                                <table>
                                    <thead>
                                        <tr>
                                            <th class="sortTable">
                                                Employee ID
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Name
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Region
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable" style="width: 13%;">
                                                Application Date
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable" style="width: 10%;">
                                                Travel Type
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Advance
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Approval Date
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                        </tr>
                                        <tr>
                                    </thead>
                                    <tbody id="travel_data">
                                        @if($data->total != 0)
                                        @foreach($data->data as $key =>$value)
                                        @php
                                            $value=(object)$value;
                                        @endphp
                                        <tr>
                                            <td>{{$value->empcod}}</td>
                                            <td>{{$value->name}}</td>
                                            <td>{{$value->e_country}}</td>
                                            <td>{{ dateFromat($value->added) }}</td>
                                            <td>{{$value->business_trip}}</td>
                                            <td>{{$value->symbol}}&nbsp;{{ number_format(abs($value->amount + 0), 0, ".", ",") }}</td>
                                            <td>{{ dateFromat($value->hr_date) }}</td>
                                        </tr>
                                        @endforeach()
                                        @else
                                            <tr>
                                                <td colspan="7" class="no_record" style="letter-spacing: 0px; color: #8D8D8D; opacity: 1; text-align: center; font-size: 16px;">No Data Found</td>
                                            </tr>
                                        @endif
                                    </tbody>
                                </table>
                            </div>
                            <div class="expense_table_footer" />
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@stop
@section('scripts')
<script src="{{ URL::asset('assets/js/calendar.js') }}"></script>
<script src="{{ URL::asset('assets/plugins/bootstrap/js/bootstrap.min.js') }}"></script>
<!-- <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/js/bootstrap-datepicker.min.js"></script> -->
<script>
    $('.dateselect').datepicker({
        format: 'dd-MM-yyyy',
    }).on('changeDate', function(e) {
        $('.datepicker').hide();
    });
    var country_id=null;
    var sDate=null;
    var eDate=null;
    var travel_type=null;
    var page = 1;
    var flag=false;
    var load_table = true;
    $('body').on('click', '.excel_travel', function(e) {
        e.preventDefault();
        sDate=$('.start_date').val();
        eDate=$('.end_date').val();
        country_id=$('.countries_select').val();
        travel_type=$('.travel_type').val();
        page = 1;
        flag=true;
        $( ".loader-wrapper" ).html('<div id="loader-body1" class="loading" ><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div></div>');
        $( ".loader-wrapper" ).show();
        var type=$(this).attr('data-key');
        $.ajax({
            url: $('.base_url').val()+'api/travel/report/download',
            type: "POST",
            headers: {
                'Authorization':localStorage.getItem("laravel_token")
            },
            data:{country_id:country_id,sDate:sDate,eDate:eDate,travel_type:travel_type,type:type},
            success:function(data){
                removeLoader();
                var fileName='../../../../../../uploads/travel.'+type;
                download(fileName,'travel.'+type);
            },
       });

    });
    $('body').on('click', '.align_search_btn', function() {
        $( ".loader-wrapper" ).html('<div id="loader-body1" class="loading" ><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div><div class="loading-bar"></div></div>');
        $( ".loader-wrapper" ).show();
        sDate=$('.start_date').val();
        eDate=$('.end_date').val();
        country_id=$('.countries_select').val();
        travel_type=$('.travel_type').val();
        page = 1;
        flag=true;
        loadMoreData();
        removeLoader();
    });
    $('.table tbody').scroll(function() {
        if ($(this).scrollTop() + $(this).innerHeight() >= $(this)[0].scrollHeight && load_table) {
            load_table = false;
            page++;
            loadMoreData();
        }
    });
    // $(window).scroll(function() {
    //     if($(window).scrollTop() + $(window).height() >= $(document).height()) {
    //         page++;
    //         loadMoreData();
    //     }
    // });
    function loadMoreData(){
        $.ajax(
            {
                url: $('.base_url').val()+'api/travel/reports',
                type: "POST",
                headers: {
                    'Authorization':localStorage.getItem("laravel_token")
                },
                data:{country_id:country_id,sDate:sDate,eDate:eDate,travel_type:travel_type,page:page,type:'report'},
                beforeSend: function()
                {
                    if(flag)
                    {
                        $('#travel_data').empty();
                    }
                }
            })
            .done(function(data)
            {
                flag=false;
                if(data.html == ""){
                    if (!$(".no_record").is(":visible")) {
                        $("#travel_data").append('<tr><td colspan="7" class="no_record" style="letter-spacing: 0px; color: #8D8D8D; opacity: 1; text-align: center; font-size: 16px;">No Data Found</td></tr>');
                        return;
                    }
                }
                $("#travel_data").append(data.html);
                load_table = true;
            })
            .fail(function(jqXHR, ajaxOptions, thrownError)
            {
                load_table = true;
                alert('server not responding...');
            });
    }
</script>

@endsection