@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>
    .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: #3080EA;
        opacity: 1;
    }
    /*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;
    }
    b{
        font-weight: unset;  important;
    }
</style>
<div class="breadcrum">
    HR Services / Expenses / <span class="text-primary">Expense 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="#" data-key="pdf" class="travel_report_download excel_expense">PDF</a>
                <span class="travel_report_download">/</span>
                <a href="" data-key="csv" class="excel_expense" >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">
                                            Expense 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;
                                                            ">Countries</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">
                                                             @if(is_array($countries))
                                                                    @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
                                                                @endif
                                                          </div>
                                                        </div>
                                                    </td>
                                                    <td>
                                                        <div class="dropdown">
                                                          <button class="dropdown_custom table_dropdown common_dropdown_properties status_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;
                                                            ">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="">All</a>
                                                                <a class="dropdown-item dropdown_option_custom" key-value="1">Pending</a>
                                                                <a class="dropdown-item dropdown_option_custom" key-value="2">Approved</a>
                                                                <a class="dropdown-item dropdown_option_custom" key-value="3">Disapproved</a>
                                                                <a class="dropdown-item dropdown_option_custom" key-value="4">Resubmit</a>
                                                          </div>
                                                        </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 submit_btn_expense">Search</button>
                                                        </div>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <div class="table" id="sorting_table">
                                <table>
                                    <thead>
                                        <tr>
                                            <th class="sortTable">
                                                Emp Code
                                                <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">
                                                Application Date
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Expense Month
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Expense Type
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                            <th class="sortTable">
                                                Amount
                                                <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>
                                            <th class="sortTable">
                                                Application Status
                                                <i class="fas fa-arrow-down ml-1 fa-xs"></i>
                                            </th>
                                        </tr>
                                        <tr>
                                    </thead>
                                    <tbody id="expense_data">
                                        @if($data->total != 0)
                                        @foreach($data->data as $key =>$value)
                                        @php
                                            $value=(object)$value;
                                        @endphp
                                        @if(isset($value->empcod))
                                        <tr>
                                            @php
                                                $exp_date='';
                                                if(isset($value->exp_date)) {
                                                    $exp_date=dateFromat($value->exp_date);
                                                }
                                                $application_status='Approved';
                                                if($value->hr_status == 1)
                                                {
                                                    $application_status='Pending';
                                                }
                                                if($value->lm_status == 3 ||  $value->hr_status == 3)
                                                {
                                                    $application_status='Disapproved';
                                                }
                                                if($value->lm_status == 4 ||  $value->hr_status == 4)
                                                {
                                                    $application_status='Resubmit';
                                                }
                                            @endphp
                                            <td>{{$value->empcod}}</td>
                                            <td>{{$value->name}}</td>
                                            <td>{{$value->e_country}}</td>
                                            <td>{{ dateFromat($value->added_on) }}</td>
                                            <td>{{$exp_date}}</td>
                                            <td>{{$value->type}}</td>
                                            <td>{{$value->symbol}}&nbsp;<b>
                                                @if ($value->tar_adv_amt)
                                                    {{ number_format(abs($value->tar_adv_amt + 0 - ($value->tamount + 0)), 0, ".", ",") }}
                                                @else
                                                    {{ number_format(abs($value->tamount + 0), 0, ".", ",") }}
                                                @endif</b>
                                            </td>
                                            <td>{{ dateFromat($value->hr_date) }}</td>
                                            <td>{!!statusName($application_status)!!}</td>
                                        </tr>
                                        @endif
                                        @endforeach()
                                        @else
                                            <tr>
                                                <td colspan="8" 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>
    </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 status_id=null;
    var sDate=null;
    var eDate=null;
    var page = 1;
    var flag=false;
    var load_table = true;
    $('body').on('click', '.excel_expense', function(e) {
        e.preventDefault();
        $( ".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/expense/report/download',
            type: "POST",
            headers: {
                'Authorization':localStorage.getItem("laravel_token")
            },
            data:{application_status:status_id,country_id:country_id,sDate:sDate,eDate:eDate,type:type},
            success:function(data){
                removeLoader();
                var fileName='../../../../../../uploads/expense.'+type;
                download(fileName,'expense.'+type);
            },
       });

    });
    $('body').on('click', '.submit_btn_expense', function() {
        country_id = $('.countries_select').val();
        status_id = $('.status_select').val();
        sDate=$('.start_date').val();
        eDate=$('.end_date').val();
        page = 1;
        flag=true;
        loadMoreData();
    });
    $('.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/expense/reports',
                type: "POST",
                headers: {
                    'Authorization':localStorage.getItem("laravel_token")
                },
                data:{application_status:status_id,country_id:country_id,sDate:sDate,eDate:eDate,page:page,type:'report'},
                beforeSend: function()
                {
                    if(flag)
                    {
                        $('#expense_data').empty();
                    }
                }
            })
            .done(function(data)
            {
                flag=false;
                if(data.html == ""){
                    if (!$(".no_record").is(":visible")) {
                        $("#expense_data").append('<tr><td colspan="8" class="no_record" style="letter-spacing: 0px; color: #8D8D8D; opacity: 1; text-align: center; font-size: 16px;">No Data Found</td></tr>');
                        return;
                    }
                }
                $("#expense_data").append(data.html);
                load_table = true;
            })
            .fail(function(jqXHR, ajaxOptions, thrownError)
            {
                load_table = true;
                alert('server not responding...');
            });
    }
</script>
@endsection