@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">
		    <a href="{{ route('accounts.mainPage') }}" style="color: #000000; border: 1px solid #eee; width: 60%; margin: 15px auto; box-shadow: 0px 0px 5px 5px #9e9c9c;">
                <i class="fa fa-home" aria-hidden="true" style="font-size: 20px; "></i>
                {{-- <img src="{{ route('accounts') }}" style="width: 20px"> --}}
                    Account Dashboard
            </a>
            <a href="{{ route('logout-submit') }}" class="pull-right" style="color: #000000; border: 1px solid #eee; -4px auto box-shadow: 0px 0px 5px 5px #9e9c9c;">
                <i class="fa fa-sign-out" aria-hidden="true" style="font-size: 20px; "></i>
                Logout
            </a>
		<ol class="breadcrumb float-right">
		</ol>
		<div class="clearfix">
            
        </div>
	</div>
</div> -->
<input type="hidden" id="menuDepartmentId" value="{{ $department_id }}">
@include('backend.account.headerMenu')
<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: 15.5%; ">
                    <div>
                        <form action="{{ route('debitCreate',$department_id) }}" method="GET">
                            <div class="row">
                                <div class="col-sm-4">
                                    <div class="form-group">
                                        <label class="control-label">Date From</label>
                                        <input type="text" name="date_from" id="date_from"  class="form-control single-date-picker-account" 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="text" name="date_to" id="date_to" class="form-control single-date-picker-account" 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>
                                    </div>
                                </div>	
                            </div>				
                        </form>
                    </div>
                </div>
                <!-- <h3 class="card-title">New Registration </h3> -->
            </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>Department</th> -->
                            <th>Voucher No</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>Department</th> -->
                            <th>Voucher No</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->department['name'] }}</td> -->
                            <td>{{ $m->voucher_no }}</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" title="download" href="{{ route('fileDownloadDebit',$m->file) }}"><i class="fa fa-fw fa-download"></i></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-voucher_no = "{{ $m->voucher_no }}" 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('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('accountDebitStore') }}" method="post" enctype="multipart/form-data">@csrf
                <input type="hidden" name="acc_depertment_id" value="{{ $department_id }}">
                <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="text" class="form-control single-date-picker-account" value="{{ date('d-m-Y') }}" name="date">
                                </div>
                            </div>
                            <!-- <div class="box-body">
                                <div class="form-group">
                                    <label>Department<span style="color:red";>*</span></label>
                                    <select class="form-control select2" style="width: 100%;" disabled>
                                        <option value="" selected="selected">Select Department</option>
                                        @if(sizeof($department) > 0)
                                        @foreach($department as $p_id)
                                        <option value="{{ $p_id->id }}" @if( $department_id == $p_id->id ) selected @endif )>{{ $p_id->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div> -->
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Nature Of Expenditure<span style="color:red";>*</span></label>
                                    <select class="form-control select2" style="width: 100%;" name="nature_of_expenditure" required>
                                        <option value="" selected="selected">Select Nature Of Expenditure</option>
                                        <option value="capital">Capital</option>
                                        <option value="revenue">Revenue</option>
                                    </select>
                                </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" 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>Cheque Date(For Cheque )</label>
                                    <input type="text" name="check_date" id="" class="form-control single-date-picker-account">
                                </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>Voucher No<span style="color:red";>*</span> </label>
                                    <input type="text" class="form-control" value="{{ old('voucher_no') }}" name="voucher_no"  placeholder="Voucher No" autocomplete="off">
                                </div>
                            </div>
                            <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>Cheque</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">
                <input type="hidden" name="acc_depertment_id" id="acc_depertment_id">
                    @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="text" class="form-control single-date-picker-account" value="{{ date('Y-m-d') }}" name="date" id="date">
                                </div>
                            </div>
                            <!-- <div class="box-body">
                                <div class="form-group">
                                    <label>Department<span style="color:red";>*</span></label>
                                    <select class="form-control select2" style="width: 100%;" disabled>
                                        <option value="" selected="selected">Select Department</option>
                                        @if(sizeof($department) > 0)
                                        @foreach($department as $p_id)
                                        <option value="{{ $p_id->id }}" @if( $department_id == $p_id->id ) selected @endif )>{{ $p_id->name }}</option>
                                        @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div> -->
                            <div class="box-body">
                                <div class="form-group">
                                    <label>Nature Of Expenditure<span style="color:red";>*</span></label>
                                    <select class="form-control select2" style="width: 100%;" id="nature_of_expenditure" name="nature_of_expenditure" required>
                                        <option value="" selected="selected">Select Nature Of Expenditure</option>
                                        <option value="capital">Capital</option>
                                        <option value="revenue">Revenue</option>
                                    </select>
                                </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>Cheque Date(For Cheque)</label>
                                    <input type="text" name="check_date" id="check_date single-date-picker-account" 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>Voucher No<span style="color:red";>*</span> </label>
                                    <input type="text" class="form-control" value="{{ old('voucher_no') }}" id="voucher_no" name="voucher_no"  placeholder="Voucher No" autocomplete="off">
                                </div>
                            </div>
                            <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>Cheque</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 });
  });
</script>
<script>
    $('document').ready(function(){
        $("#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',$('#mainUrlAccount').val()+'/accountDebitUpdate/'+id); 
        });
    });
</script>

@endsection