@extends('layouts.template')

@section('template')
<!-- Content Header -->
<section class="content-header">
    <h1>
    PURCHASE REPORT
        
        </h1>
    <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
        <li class="active">Purchase Details</li>
    </ol>
</section>
<!-- End Content Header -->
<!-- Main content -->
<section class="content">
    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-primary">

                <div class="panel-body">
                    <form class="form" action="{{ url('report/date-to-date-purchase-report') }}" id="date_form" method="post">
                        {!! csrf_field() !!}
                        <input type="hidden" name="_token" value="{{ csrf_token() }}">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="">From</label>
                                <input type="text" autocomplete="OFF" id="datepicker" name="start_date" class="form-control input-sm" @if(isset($start_date)) value="{{ $start_date }}"@endif  required/>
                            </div>
                        </div>    
                        <div class="col-md-3">
                            <div class="form-group">
                                 <label for="">To</label>
                                 <input type="text" autocomplete="OFF" id="datepicker2" name="end_date" class="form-control input-sm" @if(isset($end_date)) value="{{ $end_date }}"@endif required onchange='if(this.value != "") { this.form.submit(); }'/>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                 <br>
                                 <input type="submit" class="btn btn-sm btn-success" value="Submit">
                            </div>
                        </div>
                        <div class="col-md-3">
                           <!--  <div class="form-group">
                            <br>
                            @if(isset($start_date))
                            <a class="btn btn-warning btn-xs pull-right" href="{{ url('/report/date-to-date-purchase-report-pdf/'.$start_date.'/'.$end_date) }}" target="_blank">Print/Download as PDF</a>     
                            @endif
                            </div> -->
                        </div>  
                    </form>
                </div>
            </div>
        </div>
        @if(isset($all_purchases))                
        <div class="col-md-12">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    List Purchase
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <table class="table table-bordered" id="">
                            <thead>
                                <tr>
                                    <th>Sl No.</th>
                                    <!-- <th>Supplier</th> -->
                                    <th>Date</th>
                                    <th>Item</th>
                                    <th>Qty</th>
                                    <th>Price</th>
                                    <!-- <th>Vat %</th> -->
                                    <th>Total</th>
                                    <th>Invoice No.</th>
                                    <!-- <th>Paid</th>
                                    <th>Status</th> -->
                                </tr>
                            </thead>

                            <tbody>
                                @if(isset($all_purchases))
                                @php $qty = 0; $total =0 ; $temp_date = ''; @endphp
                                    @foreach($all_purchases as $key => $single_purchase)
                                        <tr>
                                            <td>{{ ++$key }}</td>
                                            <!-- <td>{{ $single_purchase->sup_name }}</td>  -->     
                                            <td>
                                                @if($temp_date != date('d M, Y',strtotime($single_purchase->purchase_date)))
                                                    {{ date('d M, Y',strtotime($single_purchase->purchase_date)) }}
                                                @endif
                                                @php $temp_date = date('d M, Y',strtotime($single_purchase->purchase_date)); @endphp
                                            </td>                                 
                                            <td>{{ $single_purchase->item_name }}</td>
                                            <td>{{ $single_purchase->quantity }}</td>
                                            <td>{{ $single_purchase->purchase_price }}</td>
                                            <!-- <td>{{ $single_purchase->item_vat }}</td> -->
                                            <td>{{ $net = ($single_purchase->purchase_price *  $single_purchase->quantity) + ($single_purchase->item_vat/100) * ($single_purchase->purchase_price *  $single_purchase->quantity) }}</td>

                                            <td><a href="{{ url('/purchase/memo_details/'.$single_purchase->purchase_master_id) }}">{{ $single_purchase->memo_no }}</a></td>

                                            <!-- <td>{{ $single_purchase->advanced_amount }} for Invoice# {{$single_purchase->memo_no}}</td>
                                        
                                            @if($single_purchase->status == "Due")
                                            <td class="btn-danger">{{ $single_purchase->status }}</td>
                                            @else
                                            <td class="btn-success">{{ $single_purchase->status }}</td>
                                            @endif -->
                                        </tr>
                                        @php
                                            $qty += $single_purchase->quantity; 
                                            $total += $single_purchase->purchase_price *  $single_purchase->quantity;
                                        @endphp
                                    @endforeach
                                @endif
                            </tbody>
                        </table>
                        <h4 class="text-red">Total Quantity: {{ $qty }}</h4>
                        <h4 class="text-red">Total Amount: {{ number_format($total,2) }}</h4>
                    </div>
                </div>
            </div>
        </div>
    @endif
</section>
<!-- End Main Content -->
@endsection

<script>
    $("#submit").click(function() {   //button id
        var myForm = $("#dateform");  //form id
        myForm.submit(function(e){
        e.preventDefault();
        var formData = myForm.serialize();
            $.ajax({
                url:'{{url('report/date-to-date-purchase-report')}}',
                type:'post',
                data:formData,
                success:function(data){
                //  alert('Successfully Retrived');
                //  $('#start_date,#end_date').val('');
                },
                error: function (data) {
                    alert('Something Went Wrong');
                }
            });
        });
    });    
</script>