@extends('layouts.view')
@section('title',trans('lang.expenses_report'))
@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-sm-12">
                <div class="page-title-box">
                    <div class="float-right">
                    </div>
                    <h4 class="page-title">{{trans('lang.expenses_report')}}</h4>
                </div><!--end page-title-box-->
            </div><!--end col-->
        </div><!--end row-->
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <div id="formDialog" class="card-body">
                        <h4 id="titleheadar" class="mt-0 header-title">{{trans('lang.expenses_report')}} :</h4>
                        <div class="row">
                            <div class="col-lg-12">
                                <span id="form_result"></span>
                                <form class="form-horizontal row-fluid" id="sample_form" method="post"
                                      enctype="multipart/form-data">
                                    @csrf
                                    <div class="form-group row">
                                        <label class="col-sm-2 col-form-label text-right"
                                               for="basicinput"> {{trans('lang.date_from')}}</label>
                                        <div class="col-sm-4">
                                            <input type="text" autocomplete="false" id="date_from" name="date_from"
                                                   placeholder="{{trans('lang.date_from')}} ..."
                                                   class="datepicker form-control" required>
                                        </div>
                                        <label class="col-sm-2 col-form-label text-right"
                                               for="basicinput"> {{trans('lang.date_to')}}</label>
                                        <div class="col-sm-4">
                                            <input type="text" autocomplete="false" id="date_to" name="date_to"
                                                   placeholder="{{trans('lang.date_to')}} ..."
                                                   class="datepicker form-control" required>
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <div class="col-sm-12" style="text-align: center;">
                                            <button type="button" name="action_button" id="action_button"
                                                    class="btn btn-primary">{{ trans('lang.run_report') }}</button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                    <div id="viewtable" style="display: none">
                        <div id="loader" style='text-align:center;'><img
                                src="{{ asset('assets/images/unnamed-2.gif') }}"></div>
                        <table id="resultTable" class="table table-striped table-bordered dt-responsive nowrap"
                               style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                            <thead>
                            <tr>
                                <th title="Field #2">{{trans('lang.voucher_no')}}</th>
                                <th title="Field #3">{{trans('lang.the_date')}} </th>
                                <th title="Field #4">{{trans('lang.emp_id')}}</th>
                                <th title="Field #3">{{trans('lang.empname')}} </th>
                                <th title="Field #4">{{trans('lang.expense_name')}}</th>
                                <th title="Field #5">{{trans('lang.ledger_code')}}</th>
                                  <th title="Field #4">{{trans('lang.amount')}}</th>
                                 <th title="Field #5">{{trans('lang.dr_cr')}}</th>
                                <th title="Field #6">{{trans('lang.project')}}</th>
                                <th title="Field #7">{{trans('lang.branch')}}</th>
                                <th title="Field #7">{{trans('lang.expense_category')}}</th>
                                <th title="Field #9">{{trans('lang.Custom_Field_1')}}</th>
                                <th title="Field #9">{{trans('lang.Custom_Field_2')}}</th>
                                <th title="Field #9">{{trans('lang.Narrration')}}</th>
                                <th title="Field #9">{{trans('lang.Remarks_by_Manager')}}</th>
                                <th title="Field #9">{{trans('lang.grade')}}</th>
                                <th title="Field #9">{{trans('lang.department')}}</th>
                                <th title="Field #7">{{trans('lang.unit')}}</th>
                                <th title="Field #7">{{trans('lang.category')}}</th>
                                <th title="Field #9">{{trans('lang.designation')}}</th>
                                <th title="Field #9">{{trans('lang.bank_account_number')}}</th>
                                <th title="Field #9">{{trans('lang.Custom_Field_3')}}</th>
                                <th title="Field #9">{{trans('lang.Custom_Field_4')}}</th>
                                <th title="Field #9">{{trans('lang.Custom_Field_5')}}</th>
                                <th title="Field #9">{{trans('lang.Custom_Field_6')}}</th>
                                <th title="Field #9">{{trans('lang.voucher_date')}}</th>
                                <th title="Field #9">{{trans('lang.remarks')}}</th>

                            </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div> <!-- end col -->
    </div>
    <!-- Buttons examples -->
    <script>
        $(document).ready(function () {
            $.ajaxSetup({
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                }
            });
            $('.datepicker').datepicker({
                dateFormat: 'dd-mm-yy',
            });
            $('#viewtable').hide('slow')
            $('#action_button').click(function () {
                $('#viewtable').show('slow');
                $('#formDialog').hide('slow');
                $.ajax({
                    type: 'POST',
                    url: "expenses_report_run",
                    data: {
                        'date_from': $('#date_from').val(),
                        'date_to': $('#date_to').val(),
                        "_token": "{{ csrf_token() }}",
                    },
                    beforeSend: function () {
                        // Show image container
                        $("#loader").show();
                    }
                }).done(function (data) {
                    $("#loader").hide();
                    var table = $('#resultTable').DataTable({
                        data: data.data,
                        buttons: ['copy', 'excel', 'pdf', 'colvis'],
                        columns: [

                            {
                                data: 'voucher_no'
                            },
                            {
                                data: 'the_date'
                            },
                            {
                                data: 'emp_id'
                            },
                            {
                                data: 'employee_name'
                            },
                            {
                                data: 'expense_name',
                            },
                            {
                                data: 'ledger_code',
                            },
                            {
                                data: 'amount'
                            },
                            {
                                data: 'dr_cr',
                            },
                            {
                                data: 'project',
                            },
                            {
                                data: 'branch'
                            },
                            {
                                data: 'expense_category'
                            },
                            {
                                data: 'Custom_Field_1',
                                defaultContent: "-"
                            },
                            {
                                data: 'Custom_Field_2',
                                defaultContent: "-"
                            },
                            {
                                data: 'Narrration',
                                defaultContent: "-"
                            },
                            {
                                data: 'Remarks_by_Manager',
                                defaultContent: "-"
                            },
                            {
                                data: 'grade',
                                defaultContent: "-"
                            },
                            {
                                data: 'department',
                                defaultContent: "-"
                            },
                            {
                                data: 'unit',
                            },
                            {
                                data: 'category'
                            },
                            {
                                data: 'designation',
                            },
                            {
                                data: 'bank_account_number',
                            },
                            {
                                data: 'Custom_Field_3'
                            },
                            {
                                data: 'Custom_Field_4'
                            },
                            {
                                data: 'Custom_Field_5',
                                defaultContent: "-"
                            },
                            {
                                data: 'Custom_Field_6'
                            },
                            {
                                data: 'voucher_date'
                            },
                            {
                                data: 'remarks',
                                defaultContent: "-"
                            },


                        ],
                        "columnDefs": [ {
                            "targets": 9,
                            "createdCell": function (td, cellData, rowData, row, col) {
                                if ( cellData == 'Absent' ) {
                                    $(td).css('color', 'red')
                                }
                                else {
                                    $(td).css('color', 'green')
                                }
                            }
                        } ]
                    });
                    table.buttons().container()
                        .appendTo('#viewtable .col-md-6:eq(0)');
                })
            });

        });
    </script>

@endsection