@extends('template.app')

@section('meta')
@endsection

@section('title')
Finance Master
@endsection

@section('styles')
<style>
     .highlight {
        background-color: #ffff99; /* Change to desired highlight color */
    }
</style>
@endsection

@section('content')
<!-- Flatpickr CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
<link href="https://cdn.jsdelivr.net/npm/select2@4.0.13/dist/css/select2.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css">
<style>
    #data-table th, td { 
        white-space: nowrap;
        padding: 0px !important;
        height: 20px !important;
        line-height: 35px !important;
        font-size: 15px !important;
        text-align: center;
    }
    #data-table th {
        text-align: center;
    }
    #data-table {
    table-layout: fixed;
    width: 100%;
    }
    #data-table th:nth-child(1), #data-table td:nth-child(1) {
        width: 25px !important;
    }
    
    #data-table th:nth-child(2), #data-table td:nth-child(2) { 
        width: 80px !important;
    }
    
    #data-table th:nth-child(3), #data-table td:nth-child(3) { 
        width: 65px !important;
    }
    
    #data-table th:nth-child(4), #data-table td:nth-child(4) {
        width: 50px !important;
    }
    #data-table th:nth-child(5), #data-table td:nth-child(5) {
        width: 50px !important;
    }
    #data-table th:nth-child(6), #data-table td:nth-child(6) {
        width: 50px !important;
    }
    .form-group .custom_color {
        background-color: lightgrey !important;
    }
    .width_150 {
        width: 150px;
    }
    .width_200 {
        width: 200px;
    }
    .width_250 {
        width: 250px;
    }
    .width_300 {
        width: 300px;
    }
    .table {
        min-height: 600px;
    }
</style>
<div class="page-breadcrumb">
    <div class="row">
        <div class="col-7 align-self-center">
            <h4 class="page-title text-truncate text-dark font-weight-medium mb-1">Finance Master</h4>
            <div class="d-flex align-items-center">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb m-0 p-0">
                        <li class="breadcrumb-item"><a href="{{ route('dashboard') }}" class="text-muted">Dashboard</a></li>
                        <li class="breadcrumb-item"><a href="{{ route('finance') }}" class="text-muted">Finance Master</a></li>
                        <li class="breadcrumb-item text-muted active" aria-current="page">List</li>
                    </ol>
                </nav>
            </div>
        </div>
        <div class="col-5 align-self-center">
            <div class="customize-input float-right">
                <a class="btn waves-effect waves-light btn-rounded btn-outline-primary pull-right" href="{{url('/example-xlsx/example-finance.xlsx')}}" download>Example Excel</a>
                <a class="btn waves-effect waves-light btn-rounded btn-outline-primary pull-right" data-toggle="modal" data-target="#exampleModal" href="Javascript:void(0)">Import</a>
                <!-- Export -->
                    <button class="btn waves-effect waves-light btn-rounded btn-outline-primary pull-right" type="button" data-toggle="collapse" data-target="#collapseExample" aria-expanded="false" aria-controls="collapseExample">Export</button>
                <!-- Export -->
                @canany(['finance-create'])
                    <a class="btn waves-effect waves-light btn-rounded btn-outline-primary pull-right" href="{{ route('finance.create') }}">Add New</a>
                @endcanany
            </div>
        </div>
        <div class="col-sm-8"></div>
        <div class="col-sm-4">
            <div class="col-md-12 align-self-center collapse" id="collapseExample">
                <div class="customize-input float-right">
                    <form action="{{ route('finance.export') }}" method="get">
                        <div class="row">
                            <div class="form-group col-md-6 ">
                                <select name="slug" class="form-control" required>
                                    <option value="">Select Status</option>
                                    <option value="all">All</option>
                                    <option value="active">Active</option>
                                    <option value="inactive">Inactive</option>
                                    <option value="deleted">Deleted</option>
                                </select>
                            </div>
                            <div class="form-group col-md-6">
                                <button class="btn btn-primary" type="submit">Submit</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card" style="min-width:100% !important;">
                <div class="card-body">
                    <table class="table table-bordered data-table" id="data-table">
                        <thead>
                            <tr>
                                <th>No</th>
                                <th>Company Name</th>
                                <th>Branch Name</th>
                                <th>DSA / Broker</th>
                                <th>Status</th>
                                <th>Action</th>
                            </tr>
                            <tr class="filterrow">
                                <th></th>
                                <th>
                                    <div class="search-box-container datatable-form-filter">
                                        <div class="form-group is-empty">
                                            <input type="text" name="finance_name" value="{{ request()->get('finance_name', '') }}" class="form-control text-capitalize custom_color" autocomplete="off" autofocus tabindex="1">
                                        </div>
                                    </div>
                                </th>
                                <th>
                                    <div class="search-box-container datatable-form-filter">
                                        <div class="form-group is-empty">
                                            <input type="text" name="branch_id" value="{{ request()->get('branch_id', '') }}" class="form-control text-capitalize custom_color" autocomplete="off" autofocus tabindex="2">
                                        </div>
                                    </div>
                                </th>
                                <th>
                                    <div class="search-box-container datatable-form-filter">
                                        <div class="form-group is-empty">
                                            <input type="text" name="dsa_or_broker" value="{{ request()->get('dsa_or_broker', '') }}" class="form-control text-capitalize custom_color" autocomplete="off" autofocus tabindex="3">
                                        </div>
                                    </div>
                                </th>
                                <th></th>
                                <th></th>
                            </tr>
                        </thead>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
 <!-- Modal -->
 <div class="modal fade" id="exampleModal" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h3 class="modal-title">Import</h3>
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>

            </div>
            <form action="{{ route('finance.import') }}" name="form" id="form" method="post" enctype="multipart/form-data">
                @csrf
                <div class="modal-body">
                    <div class="row">
                        <div class="form-group col-sm-12">
                            <label for="first_name">Upload File Here</label>
                            <input type="file" name="file" id="file" class="form-control" placeholder="Plese upload file here" required>
                            <span class="kt-form__help error file"></span>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="submit" class="btn btn-default">Submit!</button>
                    <button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
                </div>
            </form>
        </div>
        <!-- /.modal-content -->
    </div>
    <!-- /.modal-dialog -->
</div>
<!-- Modal -->
@endsection

@section('scripts')
<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/dataTables.bootstrap5.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
<script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/select2@4.0.13/dist/js/select2.min.js"></script>
// <script type="text/javascript">
//     var datatable;

//     $(document).ready(function() {
//                 if ($('#data-table').length > 0) {
//                     datatable = $('#data-table').DataTable({
//                             processing: true,
//                             serverSide: true,

//                             "pageLength": 25,
//                             "iDisplayLength": 25,
//                             "responsive": true,
//                             "aaSorting": [],
//                                 // "order": [], //Initial no order.
//                                 //     "aLengthMenu": [
//                                 //     [5, 10, 25, 50, 100, -1],
//                                 //     [5, 10, 25, 50, 100, "All"]
//                                 // ],

//                                 // "scrollX": true,
//                                 // "scrollY": '',
//                                 // "scrollCollapse": false,
//                                 // scrollCollapse: true,

//                                 // lengthChange: false,

//                                 "ajax": {
//                                     "url": "{{ route('finance') }}",
//                                     "type": "POST",
//                                     "dataType": "json",
//                                     "data": {
//                                         _token: "{{csrf_token()}}"
//                                     }
//                                 },
//                                 "columnDefs": [{
//                                     //"targets": [0, 5], //first column / numbering column
//                                     "orderable": true, //set not orderable
//                                 }, ],
//                                 columns: [{
//                                         data: 'DT_RowIndex',
//                                         name: 'DT_RowIndex'
//                                     },
//                                     {
//                                         data: 'name',
//                                         name: 'name'
//                                     },
//                                     {
//                                         data: 'branch_id',
//                                         name: 'branch_id'
//                                     },
//                                     {
//                                         data: 'dsa_or_broker',
//                                         name: 'dsa_or_broker'
//                                     },
//                                     {
//                                         data: 'status',
//                                         name: 'status'
//                                     },
//                                     {
//                                         data: 'action',
//                                         name: 'action',
//                                         orderable: false,
//                                     },
//                                 ]
//                             });
//                     }
//                     // Highlight row on mouseover
//             $('#data-table tbody').on('mouseover', 'tr', function() {
//                 $(this).addClass('highlight');
//             });

//             // Remove highlight on mouseout
//             $('#data-table tbody').on('mouseout', 'tr', function() {
//                 $(this).removeClass('highlight');
//             });
//                 });

//             function change_status(object) {
//                 var id = $(object).data("id");
//                 var status = $(object).data("status");

//                 if (confirm('Are you sure?')) {
//                     $.ajax({
//                         "url": "{!! route('finance.change.status') !!}",
//                         "dataType": "json",
//                         "type": "POST",
//                         "data": {
//                             id: id,
//                             status: status,
//                             _token: "{{ csrf_token() }}"
//                         },
//                         success: function(response) {
//                             if (response.code == 200) {
//                                 datatable.ajax.reload();
//                                 toastr.success('Status changed successfully', 'Success');
//                             } else {
//                                 toastr.error('Failed to change status', 'Error');
//                             }
//                         }
//                     });
//                 }
//             }
// </script>
<script type="text/javascript"> 
        $(document).ready(function() {
            (function(window, $) {
                window.LaravelDataTables = window.LaravelDataTables || {};
                window.LaravelDataTables["dataTableBuilder"] = $("#data-table").DataTable({
                    processing: true,
                    serverSide: true,
                    language: {
                        "info": "_START_ - _END_ of _TOTAL_",
                        "lengthMenu": "_MENU_ ",
                        "infoFiltered": ""
                    },
                    paging: true,
                    searching: false,
                    bSortCellsTop : true,
                    ajax: {
                        url: '{!! route("finance") !!}',
                        data: function (d) {
                            d.finance_name = jQuery(".datatable-form-filter input[name='finance_name']").val();
                            d.branch_id = jQuery(".datatable-form-filter input[name='branch_id']").val();
                            d.dsa_or_broker = jQuery(".datatable-form-filter input[name='dsa_or_broker']").val();
                        },
                        error : function(d) {}
                    },
                    columns: [
                        {data: 'DT_RowIndex', name: 'DT_RowIndex', class: 'text-center DT_RowIndex', title: 'No.', orderable: false, width: 100, default: true},
                        {data: 'finance_name', name: 'finance_name', class: 'text-center finance_name', title: 'Company Name', orderable: false, default: true},
                        {data: 'branch_id', name: 'branch_id', class: 'text-center branch_id', title: 'Branch Name', orderable: false, default: true},
                        {data: 'dsa_or_broker', name: 'dsa_or_broker', class: 'text-center dsa_or_broker', title: 'DSA/Broker', orderable: false, default: true},
                        {data: 'status', name: 'status', class: 'text-center status', title: 'Status', orderable: false, default: true},
                        {data: 'action', name: 'action', title: 'Action', orderable: false, searchable: false, width: 50, class: 'text-center action_column', default: true}
                    ],
                    lengthMenu: [
                        [25, 50,100, -1 ],['25', '50','100', 'Show all' ]
                    ],
                    order: [],
                    responsive: true,
                        colReorder:{
                        enable: false,
                    },
                    dom: '<"top"f>rt<"bottom"ipl><"clear">',
                    fnInitComplete: function(settings, json) {
                        jQuery('table.table input:checkbox').map(function() {
                            if(jQuery(this).prop("checked") != true){
                                var column = table.column( jQuery(this).attr('data-column') );
                                column.visible(false);
                            }
                        });
                    },
                    pageLength: 25,
                });
            })(window, jQuery);
            
            //function change_status(object) {
                $(document).on('click', '.change-status', function () {
                    var id = $(this).data("id");
                    var status = $(this).data("status");

                    if (confirm('Are you sure?')) {
                        $.ajax({
                            "url": "{!! route('finance.change.status') !!}",
                            "dataType": "json",
                            "type": "POST",
                            "data": {
                                id: id,
                                status: status,
                                _token: "{{ csrf_token() }}" 
                            },
                            success: function(response) {
                                if (response.code == 200) {
                                    $('#datatable').DataTable().ajax.reload();
                                    toastr.success('Status changed successfully', 'Success');
                                } else {
                                    toastr.error('Failed to change status', 'Error');
                                }
                            }
                        });
                    }
                });    
            //}
        });  
        
        jQuery('.datatable-form-filter input').on('keyup', function (e) {
            if(jQuery(this).val().length >= 3 || e.keyCode == 13 || !jQuery(this).val()) {
                window.LaravelDataTables["dataTableBuilder"].draw();
                e.preventDefault();
            }
        });

        jQuery('.datatable-form-filter select').on('change', function (e) {
            window.LaravelDataTables["dataTableBuilder"].draw();
            e.preventDefault();
        });

        jQuery('input:checkbox[name="name_sort_asc"],input:checkbox[name="name_sort_desc"]').on('click', function (e) {
            window.LaravelDataTables["dataTableBuilder"].draw();
            e.preventDefault();
        });
</script>
@endsection