@extends('backend.layouts.app')
<link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0/css/bootstrap.css" rel="stylesheet">
<link href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap4.min.css" rel="stylesheet">
<script src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<style>
    table thead tr th{
        font-size:11px;
    }
</style>
<script>
    $('document').ready(function(){
        var table = $('#example').DataTable({
            language: {
                "lengthMenu": "Display _MENU_ Records",
                'paginate': {
                    'previous': '<span> <i class="fa fa-arrow-circle-left" style=" font-size: 18px; " aria-hidden="true"></i></span>',
                    'next': '<span><i class="fa fa-arrow-circle-right" style=" font-size: 18px; " aria-hidden="true"></i></span>',
                },
            },
            "lengthMenu": [[5,10,50,100,300,500, -1], [5,10,50,100,300,500, "All"]],
            'ordering':false,
            initComplete: function () {
                this.api().columns([1,2,3,4,5]).every(function () {
                    var column = this;
                    var select = $('<select class="form-control select2"><option value="">Search</option></select>')
                        .appendTo($(column.header()).empty()).on('change', function () {
                            var val = $.fn.dataTable.util.escapeRegex($(this).val());
                            column.search(val ? '^' + val + '$' : '', true, false).draw();
                        });
                    column.data().unique().sort().each(function (d, j) {
                        select.append('<option value="' + d + '">' + d + '</option>');
                    });
                });
            },
            "infoCallback": function( settings, start, end, max, total, pre ) {
                var api = this.api();
                var pageInfo = api.page.info();
                var htmlView = '<strong>Total Records: '+total+'</strong>'
                return htmlView;
            },
        });
        // $(".filterhead").each( function ( i ) {
        //     var select = $('<select class="select2" width="100%;"><option value="">Search</option></select>')
        //     .appendTo( $(this).empty() )
        //     .on( 'change', function () {
        //        var term = $(this).val();
        //         table.column().search(term, false, false ).draw();
        //     } );
 	    //      table.column().data().unique().sort().each( function ( d, j ) {
        //           console.log(j);
        //     	select.append( '<option value="'+d+'">'+d+'</option>' )
        //     } );
		// } );
        $('.select2').select2();
    }); 
</script>

@section('content')

<div class="col-xl-12">
    <div class="breadcrumb-holder">
		<h5 style="text-align: center"> Accounts Details</h5>
		    <a href="{{ route('sw.acc.dashboard') }}" class="btn btn-success" style="color: #000000; border: 1px solid #eee; margin: 0px auto;">
                <i class="fa fa-home" aria-hidden="true" style="font-size: 20px; "></i>
                {{-- <img src="{{ route('accounts') }}" style="width: 20px"> --}}
                    Account Dashboard
            </a>
		<ol class="breadcrumb float-right">
		</ol>
		<div class="clearfix"></div>
	</div>
</div>
<div class="container-fluid">
	<div class="col-md-12">
		<div style="text-align: right; margin-bottom: 20px;">
            <u> <h5 style="text-align: center"> Debit Entry</h5></u>
        </div>
        <div class="card">
        
            <div class="card-header" style=" display: inline-flex; ">
                <div class="col-md-4">
                    <p> <b style=" font-size: 15px; ">New Debit Entry</b> </p>
                    <div class="btn-group" style="left: 11px;">
                        <button type="button" class="btn btn-info" data-toggle="modal" data-target="#create"><i class="fa fa-fw fa-plus-square"></i></button>
                    </div>
                </div>
                <div class="col-md-8" style=" left: 10.5%; ">
                    <div>
                        <form action="#" method="GET">
                            <div class="row">
                                <div class="col-sm-4">
                                    <div class="form-group">
                                        <label class="control-label">Date From</label>
                                        <input type="date" name="date_from" id="date_from" class="form-control" value="@if(request()->date_from){{ request()->date_from }}@else{{ $date_from }}@endif" autocomplete="off"/>
                                    </div>
                                </div>
                                <div class="col-sm-4">
                                    <div class="form-group">
                                        <label class="control-label">Date To</label>
                                        <input type="date" name="date_to" id="date_to" class="form-control" value="@if(request()->date_to){{ request()->date_to }}@else{{ $date_to }}@endif"  autocomplete="off"/>
                                    </div>
                                </div>
                                <div class="col-sm-4" style="padding-top: 30px;">
                                    <div class="form-group">
                                        <button type="submit" class="btn btn-info"><i class="fa fa-search"></i></button>
                                        <button type="submit" id="printFullReport" class="btn btn-info"><i class="fa fa-print"></i></button>
                                    </div>
                                </div>	
                            </div>				
                        </form>
                    </div>
                </div>
                <!-- <h3 class="card-title">New Registration </h3> -->
            </div>    
            <div style="float: right;">
                <form target="_blank" action="{{ route('reportDebitPrintSwimming') }}" method="get" id="printFullReportForm">
                    <input type="hidden" name="date_from_2" id="date_form_2">
                    <input type="hidden" name="date_to_2" id="date_to_2">
                </form>
            </div>        
            <div class="card-body">		
                <table class="table table-striped table-bordered" id="example" style="width: 100%;">
                    <thead>
                        <tr>
                            <th>Sl</th>
                            <th>Date</th>
                            <th>Expenditure</th>
                            <th>Payment</th>
                            <th>Amount-BDT</th>
                            <th>Remarks</th>
                            <th>File</th>
                            <th>Action</th>
                        </tr>
                        <tr  class="filte">
                            <th>Sl</th>
                            <th>Date</th>
                            <th>Expenditure</th>
                            <th>Payment</th>
                            <th>Amount-BDT</th>
                            <th>Remarks</th>
                            <th>File</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        @if(sizeof($model) > 0)
                        @foreach($model as $m)
                        <tr>
                            <td>{{ ++$sl }}</td>
                            <td>{{ date('d/m/Y',strtotime($m->date)) }}</td>
                            <td>{{ $m->expenditure['name'] }}</td>
                            <td>{{ $m->payment_method['name'] }}</td>
                            <td>{{ $m->amount }}</td>
                            <td>{{ $m->remarks }}</td>
                            <td>
                                @if($m->file)
                                    <a target="_blank" href="{{ route('sfileDownloadDebit',$m->file) }}">download</a>
                                @else
                                    N/A
                                @endif
                            </td>
                                <td>
                                <a class="btn btn-success" data-toggle="modal" data-target="#edit" data-target-id = "{{$m->id}}" 
                                    data-date = "{{ $m->date }}" data-department = "{{ $m->acc_depertment_id }}" data-p_method_id = "{{ $m->p_method_id }}"
                                    data-remarks = "{{ $m->remarks }}" data-expenditure_id = "{{ $m->expenditure_id }}"
                                    data-amount = "{{ $m->amount }}"  
                                    data-nature_of_expenditure = "{{ $m->nature_of_expenditure }}"
                                    data-bank_id = "{{ $m->bank_id }}" data-check_date = "{{ $m->check_date }}"
                                    data-check_or_card_no = "{{ $m->check_or_card_no }}"
                                    >
                                    <i class="fa fa-fw fa-edit"></i>
                                </a>
                                <a class="btn btn-danger item-delete-btn btn-sm" href="{{ route('sw.acc.debit-delete',$m->id) }}"><i class="fa fa-times"></i></a>
                            </td>
                        </tr>
                        @endforeach
                        @endif
                    </tbody>
                </table>			
            </div>
        </div>			
	</div>
</div>
<div class="modal fade" id="create">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Add Debit Entry</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span></button>
            </div>
            <form id="store" action="{{ route('debit-entry.store') }}" method="post" enctype="multipart/form-data">@csrf
                <div class="modal-body">
                    @if($errors->any())
                    <div id="error-box">
                        <span style="color:red;">{{ $errors }}</span>
                    </div>
                    @endif
                    <div class="row">
                        <div class="col-md-6">
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Date<span style="color:red";>*</span> </label>
                                    <input type="date" class="form-control" value="{{ date('Y-m-d') }}" name="date">
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Payment Method<span style="color:red";>*</span></label>
                                    <select class="form-control select2" name="p_method_id" id="p_method" style="width: 100%;" required>
                                        <option value="" selected="selected">Select Payment Method</option>
                                        @if(sizeof($p_method) > 0)
                                        @foreach($p_method as $p_id)
                                        <option value="{{ $p_id->id }}" @if( old('p_method_id')== $p_id->id ) selected @endif )>{{ $p_id->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Bank Name</label>
                                    <select class="form-control select2" name="bank_id" style="width: 100%;" id="bank">
                                        <option value="" selected="selected">Select Bank </option>
                                        @if(sizeof($bank_list) > 0)
                                        @foreach($bank_list as $p_id)
                                        <option value="{{ $p_id->id }}" @if( old('bank_id')== $p_id->id ) selected @endif )>{{ $p_id->bank_cr_name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Check Date(For Check)</label>
                                    <input type="date" name="check_date" id="" class="form-control">
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Remarks</label>
                                    <textarea type="text" class="form-control" value="{{ old('remarks') }}" name="remarks" placeholder="Remarks" autocomplete="off"></textarea>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Expenditure<span style="color:red";>*</span></label>
                                    <select class="form-control select2" name="expenditure_id" style="width: 100%;" required>
                                        <option value="" selected="selected">Select Expenditure</option>
                                        @if(sizeof($expenditure) > 0)
                                        @foreach($expenditure as $p_id)
                                        <option value="{{ $p_id->id }}" @if( old('expenditure_id')== $p_id->id ) selected @endif )>{{ $p_id->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Amount<span style="color:red";>*</span> </label>
                                    <input type="number" step="any" class="form-control" value="{{ old('amount') }}" name="amount" placeholder="Amount" autocomplete="off" id="amount">
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Check</label>
                                    <input type="text" name="check_or_card_no" id="" class="form-control">
                                </div>
                            </div>
                            <div>
                                <div class="form-group">
                                    <label>File</label>
                                    <input type="file" step="any" class="form-control" value="{{ old('file') }}" name="file" placeholder="Amount" autocomplete="off" >
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger pull-left" data-dismiss="modal">Close</button>
                    <button type="submit" class="btn btn-success">Submit</button>
                </div>
            </form>
        </div>
    </div>
</div>
<div class="modal fade" id="edit">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Edit Debit Entry</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span></button>
            </div>
            <form id="editForm" action="" method="post" enctype="multipart/form-data">
            @method('put')
            @csrf
                <div class="modal-body">
                    @if($errors->any())
                    <div id="error-box">
                        <span style="color:red;">{{ $errors }}</span>
                    </div>
                    @endif
                    <div class="row">
                        <div class="col-md-6">
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Date<span style="color:red";>*</span> </label>
                                    <input type="date" class="form-control" value="{{ date('Y-m-d') }}" name="date" id="date">
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Payment Method<span style="color:red";>*</span></label>
                                    <select class="form-control select2" name="p_method_id" id="p_method_id" style="width: 100%;" required>
                                        <option value="" selected="selected">Select Payment Method</option>
                                        @if(sizeof($p_method) > 0)
                                        @foreach($p_method as $p_id)
                                        <option value="{{ $p_id->id }}" @if( old('p_method_id')== $p_id->id ) selected @endif )>{{ $p_id->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Bank Name</label>
                                    <select class="form-control select2" name="bank_id" id="bank_id" style="width: 100%;" id="bank">
                                        <option value="" selected="selected">Select Bank </option>
                                        @if(sizeof($bank_list) > 0)
                                        @foreach($bank_list as $p_id)
                                        <option value="{{ $p_id->id }}" @if( old('bank_id')== $p_id->id ) selected @endif )>{{ $p_id->bank_cr_name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Check Date(For Check)</label>
                                    <input type="date" name="check_date" id="check_date" class="form-control">
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Remarks</label>
                                    <textarea type="text" class="form-control" value="{{ old('remarks') }}" id="remarks" name="remarks" placeholder="Remarks" autocomplete="off"></textarea>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Expenditure<span style="color:red";>*</span></label>
                                    <select class="form-control select2" name="expenditure_id" id="expenditure_id" style="width: 100%;" required>
                                        <option value="" selected="selected">Select Expenditure</option>
                                        @if(sizeof($expenditure) > 0)
                                        @foreach($expenditure as $p_id)
                                        <option value="{{ $p_id->id }}" @if( old('expenditure_id')== $p_id->id ) selected @endif )>{{ $p_id->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Amount<span style="color:red";>*</span> </label>
                                    <input type="number" step="any" class="form-control" value="{{ old('amount') }}" name="amount" placeholder="Amount" autocomplete="off" id="amount">
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Check</label>
                                    <input type="text" name="check_or_card_no" id="check_or_card_no" class="form-control">
                                </div>
                            </div>
                            <div>
                                <div class="form-group">
                                    <label>File</label>
                                    <input type="file" step="any" class="form-control" value="{{ old('file') }}" name="file" placeholder="Amount" autocomplete="off" >
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger pull-left" data-dismiss="modal">Close</button>
                    <button type="submit" class="btn btn-success">Update</button>
                </div>
            </form>
        </div>
    </div>
</div>
<input type="hidden" id="modalValue" value="{{ Session::get('modal') }}">
@endsection

@section('modal_content')

@endsection
@section('page_script')>
<script>
  $('document').ready(function(){
    var err = $('#modalValue').val();
    $('#create').modal({ 'show' : err =="create" ? true : false });
    $('#edit').modal({ 'show' : err =="edit" ? true : false });
    $('#printFullReport').click(function(){
        var date_from = $('#date_from').val();
        $('#date_form_2').val(date_from);
        var date_to = $('#date_to').val();
        $('#date_to_2').val(date_to);
        document.getElementById('printFullReportForm').submit();
        //$(this).attr('href',$('#mainUrlSwmiimg').val()+'/totalPrintView/'+'date_from='+date_from+'&date_to='+date_to);
    });
  });
</script>
<script>
    $('document').ready(function(){
        $('#p_method option')
        .filter(function() { return $.trim( $(this).text() ) == 'Cash'; })
        .attr('selected',true);
        $("#edit").on("show.bs.modal", function(e) { 
            var id = $(e.relatedTarget).data('target-id');
            var acc_depertment_id = $(e.relatedTarget).data('department'); 
            var date = $(e.relatedTarget).data('date'); 
            var p_method_id = $(e.relatedTarget).data('p_method_id'); 
            var remarks = $(e.relatedTarget).data('remarks'); 
            var voucher_no = $(e.relatedTarget).data('voucher_no'); 
            var expenditure_id = $(e.relatedTarget).data('expenditure_id'); 
            var amount = $(e.relatedTarget).data('amount'); 
            var nature_of_expenditure = $(e.relatedTarget).data('nature_of_expenditure'); 
            var bank_id = $(e.relatedTarget).data('bank_id'); 
            var check_date = $(e.relatedTarget).data('check_date'); 
            var check_or_card_no = $(e.relatedTarget).data('check_or_card_no'); 

            $('.modal-body #acc_depertment_id').val(acc_depertment_id);
            $('.modal-body #date').val(date);
            $('.modal-body #p_method_id').val(p_method_id).change();
            $('.modal-body #remarks').val(remarks);
            $('.modal-body #voucher_no').val(voucher_no);
            $('.modal-body #expenditure_id').val(expenditure_id).change();

            $('.modal-body #amount').val(parseFloat(amount));
            if(nature_of_expenditure == ''){
                nature_of_expenditure = 'revenue';
            }
            $('.modal-body #nature_of_expenditure').val(nature_of_expenditure).change();
            $('.modal-body #bank_id').val(bank_id).change();
            $('.modal-body #check_date').val(check_date);
            $('.modal-body #check_or_card_no').val(check_or_card_no);
            
            $('#editForm').attr('action',$('#currentUrl').val()+'/'+id); 
        });
    });
</script>

@endsection