@include('includes/header')

<!-- /////////////////////////////////// MAIN CONTENT /////////////////////////////////////////-->

<style>
    .modal-dialog {
        position: fixed;
        margin: auto;
        height: 100%;
        right: 0px;
    }

    .modal-content {
        height: 100%;
    }

    .table td {
        white-space: nowrap;
    }
</style>

@include('includes/sidebar')

<div class="app-content content">

    <div class="content-wrapper">

        <div class="content-header row">
            <div class="content-header-left col-md-12 col-12 mb-2">
                <h1 class="content-header-title mb-0">Employee Expense Request Report</h1>
            </div>
        </div>

        <div class="content-body">
            <div class="section">
                <div class="row">
                    @if (\Session::has('success'))
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <strong>{!! \Session::get('success') !!}</strong>
                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    @endif

                    @if (\Session::has('error'))
                    <div class="alert alert-warning alert-dismissible fade show" role="alert">
                        <strong>{!! \Session::get('error') !!}</strong>
                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    @endif
                    <div class="card w-100">
                        <div class="employee-table p-2">
                            <form class="form">
                                <div class="form-body">
                                    <div class="row justify-content-center align-items-center">
                                        <div class="col-md-3">
                                            <label for="">Employee</label>
                                            <div class="form-group">
                                                <select class="form-control" name="emp_id" onchange="" style="max-height: 100px; overflow-y:auto">
                                                    @foreach($users as $val)
                                                    <option value="{{$val['id']}}" @if( isset($_GET['emp_id']) && $_GET['emp_id']==$val['id'] ) selected @endif>
                                                        {{ $val['FirstName'] . ' ' . $val['LastName'] }}
                                                    </option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <label for="">From Date</label>
                                            <div class="form-group">
                                                <input type="date" class="form-control" name="from_date" value="" required>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <label for="">To Date</label>
                                            <div class="form-group">
                                                <input type="date" class="form-control" name="to_date" value="" required>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <label for=""></label>
                                            <div class="form-group">
                                                <button class="btn btn-primary" type="submit">Generate Report</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                            <div class="btn-toolbar justify-content-between mb-1" role="toolbar"
                                aria-label="Toolbar with button groups">
                                <div class="btn-group" role="group" aria-label="First group">
                                    <button type="button" class="btn btn-secondary" onclick="exportEmployeeExpenseReport('excel')">Export Report</button>
                                </div>
                                {{-- <form method="get">
                                    <div class="input-group">                                        
                                        <div class="input-group-prepend">
                                            <div class="input-group-text" id="btnGroupAddon2">Search: </div>
                                        </div>
                                        <input type="text" name="search" class="form-control" @if(isset($_GET['search'])) value="{{$_GET['search']}}" @endif >
                                <div class="input-group-append">
                                    <button class="btn btn-primary" type="submit"><i class="fa fa-search"></i></button>
                                </div>
                            </div>
                            </form> --}}
                        </div>
                        <div class="table-responsive" id="printableArea">
                            <table class="table table-bordered" id="custom_table">
                                <thead>
                                    <tr>
                                        <th>For Date</th>
                                        <th>Description</th>
                                        <th>Request On</th>
                                        <th>Action</th>
                                        @foreach ($expenseTypes as $type)
                                        <th>{{ $type }}</th>
                                        @endforeach
                                        <th>Total</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if(count($expenseReport) > 0)

                                    @foreach ($expenseReport as $date => $entries)
                                    @php
                                    $dailyTotal = 0;
                                    $pendingTotal = 0;
                                    $approvedTotal = 0;
                                    $rejectedTotal = 0;
                                    @endphp

                                    @foreach ($entries as $index => $entry)
                                    <tr>
                                        @if ($index == 0)
                                        <td rowspan="{{ count($entries) }}">{{ $date }}</td>
                                        @endif
                                        <td>{{ $entry['remark'] }}</td>
                                        <td>{{ $entry['created_at'] }}</td>
                                        <td>
                                            @if ($entry['status'] == 2)
                                            <b> Status: </b> Approved <br>
                                            <b> Approved By: </b> {{ $entry['approved_by'] }} <br>
                                            <b> Approved On: </b> {{ $entry['approved_on'] }}
                                            @php $approvedTotal += $entry['amount']; @endphp
                                            @elseif ($entry['status'] == 1)
                                            <b> Status: </b>Rejected <br>
                                            <b> Rejected By: </b> {{ $entry['rejected_by'] }} <br>
                                            <b> Rejected ON: </b> {{ $entry['rejected_on'] }} <br>
                                            <b>Reason: </b> {{$entry['reject_reason']}}

                                            @php $rejectedTotal += $entry['amount']; @endphp
                                            @else
                                            <b> Status: </b>Pending
                                            @php $pendingTotal += $entry['amount']; @endphp
                                            @endif
                                        </td>

                                        @foreach ($expenseTypes as $type)
                                        <td>
                                            @if ($entry['expense_type'] == $type)
                                            {{ '₹ ' . $entry['amount'] }} <br>
                                            {{-- dev --}}
                                            @if ($entry['status'] == 2)
                                            Approved <strong>{{ '₹ ' . $entry['amount'] }}</strong>
                                            @elseif ($entry['status'] == 1)
                                            Rejected <strong>{{ '₹ ' . $entry['amount'] }}</strong>
                                            @else
                                            Pending <strong>{{ '₹ ' . $entry['amount'] }}</strong>
                                            @endif

                                            @php $dailyTotal += $entry['amount']; @endphp
                                            @endif
                                        </td>
                                        @endforeach

                                        <td></td>
                                    </tr>
                                    @endforeach

                                    <tr>
                                        <td colspan="{{ count($expenseTypes) + 5 }}" align="right">
                                            <b>Pending: </b>{{ '₹ ' . $pendingTotal }} <br>
                                            <b>Approved: </b>{{ '₹ ' . $approvedTotal }} <br>
                                            <b>Rejected: </b>{{ '₹ ' . $rejectedTotal }} <br>
                                            <b>Total: {{ '₹ ' . $dailyTotal }}</b>
                                        </td>
                                    </tr>
                                    @endforeach
                                    <tr class="bg-dark text-light">
                                        <!-- Approved only expense type start -->
                                        <td colspan="4" align="right"><b>Total:</b></td>
                                        @foreach ($expenseTypes as $type)
                                        <td><b>₹ {{ $totalApprovedByType[$type] ?? 0 }}</b></td>
                                        @endforeach
                                        <!-- Approved only expense type start -->
                                        <td colspan="{{ count($expenseTypes) + 5 }}" align="right">
                                            <b>Total Pending: </b>{{ '₹ ' . $total_pending }} <br>
                                            <b>Total Approved: </b>{{ '₹ ' . $total_approved }} <br>
                                            <b>Total Rejected: </b>{{ '₹ ' . $total_rejected }} <br>
                                            <b>Total: {{ '₹ ' . $total }}</b>
                                        </td>
                                    </tr>
                                    @else
                                    <tr>
                                        <td colspan="{{ 5 + count($expenseTypes ?? []) }}" class="text-center">No Data Found!</td>
                                    </tr>
                                    @endif
                                </tbody>
                            </table>
                        </div>
                        {{-- {{$data->render('custom_pagination')}} --}}
                    </div>
                </div>
            </div>

        </div>

    </div>
</div>
</div>

<!-- /////////////////////////////////// MAIN CONTENT /////////////////////////////////////////-->

<script>
    var base_url = "{{env('BASE_URL')}}";

    function downloadPdf() {

        $.ajax({
            url: 'pdf-attendance-reports',
            type: 'GET',
            data: {
                date: exp_req_id,
                emp_id: exp_req_id
            },
            success: function(response) {
                if (response.status) {
                    console.log(response.data);
                    $("#user").text(response.data.user);
                    $("#approved_by").text(response.data.approved_by);
                    $("#approved_on").text(response.data.approved_on);
                    $("#amount").text(response.data.amount);
                    $("#approved_amount").text(response.data.approved_amount);
                    $("#expense_type").text(response.data.expense_type);
                    if (response.data.status == 2) {
                        $("#status").text("Approved");
                    } else if (response.data.status == 1) {
                        $("#status").text("Rejected");
                    } else {
                        $("#status").text("Pending");
                    }
                    $("#remarks").text(response.data.remarks);
                    $("#created_on").text(response.data.created_on);
                    $("#updated_on").text(response.data.updated_on);
                } else {
                    console.log('error');
                }
            }
        });

    }

    function exportEmployeeExpenseReport(extention) {
        console.log(extention);

        $.ajax({
            url: base_url + 'export/employee/expense',
            type: 'GET',
            data: {
                ext: extention,
                emp_id: @isset($_GET['emp_id'])
                "{{ $_GET['emp_id'] }}"
                @else 0 @endisset,
                from_date: @isset($_GET['from_date'])
                "{{ $_GET['from_date'] }}"
                @else 0 @endisset,
                to_date: @isset($_GET['to_date'])
                "{{ $_GET['to_date'] }}"
                @else 0 @endisset
            },
            success: function(result) {
                if (result) {
                    console.log(result.data);
                    const link = document.createElement('a');
                    link.href = result.data.url;
                    link.download = result.data.file_name;
                    document.body.appendChild(link);
                    link.click();
                    document.body.removeChild(link);
                } else {
                    console.log('Error');
                }
            }
        });
    }

    function printDiv(divId) {
        var printContents = document.getElementById(divId).innerHTML;
        var originalContents = document.body.innerHTML;

        document.body.innerHTML = printContents;

        window.print();

        document.body.innerHTML = originalContents;
    }
</script>

@include('includes/footer')