@extends('layouts.backend_app')
@section('content')
<div>
    <x-slot name="title">
        Vendor Ledger
    </x-slot>
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="search-box mr-2 mb-2 d-inline-block">
                                <div class="position-relative">
                                    <h4 class="card-title design_title">Vendor Ledger</h4>
                                </div>
                            </div>
                        </div>
                    </div>
                    <hr>
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="row">
                                <div class="col-md-4">
                                    <div class="form-group">
                                        <label for="basicpill-firstname-input">From Date</label>
                                        {{-- prevDate --}}
                                        <input type="date" class="form-control updateTable " id="from_date"
                                            name="from_date" />
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="form-group">
                                        <label for="basicpill-firstname-input">To Date</label>
                                        {{-- currentDate --}}
                                        <input type="date" class="form-control updateTable " id="to_date"
                                            name="to_date" />
                                    </div>
                                </div>
                                <div class="col-lg-4">
                                    <div class="form-group">
                                        <label for="basicpill-firstname-input">Vendor</label>
                                        <select class="form-control form-select select2 updateTable"
                                            placeholder="vendor_id" name="vendor_id" id="vendor_id">
                                            <option value="">Select Vendor</option>
                                            @foreach ($vendors as $item)
                                            <option value="{{ $item->id }}">{{ $item->business_name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-xl-12">
            <div class="card">
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="vendor_ledger_table" class="table table-striped table-bordered nowrap"
                            style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<script>

    $(document).ready(function() {
        $('#vendor_id').select2();
        $('#vendor_id').on('change', function(e) {
            var data = $('#vendor_id').select2("val");
        });
    });

    $(document).ready(function(){
        $('.currentDate').val(getDateFormat());
		$('#vendor_ledger_table').DataTable({
			processing: true,
			responsive: true,
			serverSide: true,
			ordering: false,
			paging: false,
			order: [[ 2, "desc" ]],
			ajax: {
				url: "{{ route('vendor-ledger-data') }}",
				type: 'GET',
				cache: false,
				data : function ( d ) {
                    d.from_date = $('#from_date').val();
					d.to_date = $('#to_date').val();
					d.vendor_id = $('#vendor_id').val();
				}
			},
			columns: [
			{ title: 'SL', targets: 1,  data: 'id', name: 'id' },
			{ title: 'Product Name',  data: 'product_id', name: 'product_id' },
			{ title: 'Qty',  data: 'quantity', name: 'quantity' },
			{ title: 'Unit Price',  data: 'unit_price', name: 'unit_price' },
			{ title: 'Amount',  data: 'amount', name: 'amount' },
			{ title: 'Balance',  data: 'amount', name: 'amount' },
			],
			dom: '<"html5buttons"B>lTfgitp',
			buttons: [
			'copyHtml5',
			'csvHtml5',
			{extend: 'excelHtml5',
            title: '{{$companyInfo->business_name}} \n {{$companyInfo->address}} \n Vendor Ledger',
            messageTop: function() {
                return 'Vendor Name : '+$('#vendor_id :selected').text()+' ';
            },
				exportOptions:{
					// columns: ":not(.not-show)"
                    columns: ':visible'
				},
			},
			{
            extend: 'pdfHtml5',
            title: '{{$companyInfo->business_name}} \n {{$companyInfo->address}} \n Vendor Ledger',
            orientation: 'landscape',
            messageTop: function() {
                return 'Vendor Name : '+$('#vendor_id :selected').text()+' ';
            },
            pageSize: 'LEGAL',
				exportOptions:{
					charset: "utf-8",
					columns: ":not(.not-show)"
				},
				customize: function (doc) {
                    // alert(Array(doc.content[2].table.body[0].length + 1).join('*').split(''));
					doc.content[2].table.widths =
					Array(doc.content[2].table.body[0].length + 1).join('*').split('');
					doc.styles.tableFooter.alignment = 'center';
					doc.styles.tableBodyEven.alignment = 'center';
					doc.styles.tableBodyOdd.alignment = 'center';
				}
			}
			],
			drawCallback : function ( settings ) {
				var api = this.api();
				var rows = api.rows( {page:'current'} ).nodes();
				var last=null;

			},
			lengthMenu: [
			[-1],
			["All"]
			]
		});

		$(document).on('change','.updateTable',function () {
			$('#vendor_ledger_table').DataTable().draw(true);
		});
	});
</script>
@endsection