@extends('layouts.app')
@section('content')

@section('css')
<link rel="stylesheet" type="text/css" href="{{asset('assets/admin/vendors/css/tables/datatable/dataTables.bootstrap4.min.css')}}">
<link rel="stylesheet" type="text/css" href="{{asset('assets/admin/vendors/css/ui/jquery-ui.min.css')}}">
<style>
.center{text-align: center;}
.left{text-align: left;}
.right{text-align: right !important;}
table td{
    padding: 2px !important; 
}
</style>
@endsection

<div class="row">
    <div class="col-xs-12">
        <div class="card">
            <div class="card-header">
                <h4 class="card-title">{{ isset($title)?$title:'Reports' }}</h4>
                <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                <div class="heading-elements">
                </div>
            </div>
            <div class="card-body collapse in">
                <form method="GET" action="{{route('detailReport')}}">
                    <div class="card-block">
                        <div class="row">
                            
                            <div class="col-md-4">
                                <div class="row">
                                    <div class="col-md-6">
                                        <input type="text" class="form-control datepicker" name="from_date" value="{{Request::input('from_date')}}" placeholder="From Date" />
                                    </div>
                                    <div class="col-md-6">
                                        <input type="text" class="form-control datepicker" name="to_date" value="{{Request::input('to_date')}}" placeholder="To Date" />
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-4">
                                <select name="user" class="form-control select2">
                                    <option value="">Uers</option>
                                    @foreach($users as $row)
                                        <option @if(Request::input('user') == $row->id) selected @endif value="{{$row->id}}">{{$row->name}}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-4">
                                <select name="order" class="form-control select2">
                                    <option value="">Order/Bill No</option>
                                    @foreach($orders as $row)
                                        <option @if(Request::input('order') == $row->id) selected @endif value="{{$row->id}}">{{$row->id}}</option>
                                    @endforeach
                                </select>
                            </div>

                        </div>

                        <div class="row" style="padding-top:20px">

                            <div class="col-md-4">
                                <select name="category" class="form-control select2">
                                    <option value="">Category</option>
                                    @foreach(\App\MenuCategories::where('status',1)->get() as $row)
                                        <option @if(Request::input('category') == $row->category_id) selected @endif value="{{$row->category_id}}">{{$row->category_name}}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-4">
                                <select name="item" class="form-control select2">
                                    <option value="">Item</option>
                                    @foreach(\App\MenuItems::where('status',1)->get() as $row)
                                        <option @if(Request::input('item') == $row->menu_item_id) selected @endif value="{{$row->menu_item_id}}">{{$row->menu_item_name}}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-4">
                                <button type="submit" name="submit" value="reports" class="btn btn-success">Get Report</button>
                            </div>
                            
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-xs-12">
        <div class="card">

            <div class="card-body collapse in">
              
                <div class="card-block">
                    
                    <!-- sale -->
                    <div class="card-header">
                        <h4 class="card-title">Sales</h4>
                        <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                        <div class="heading-elements">
                        </div>
                    </div>

                    <div class="row" id="" style="margin-top:20px;">
                        <div class="col-sm-12">
                            <div class="card-box table-responsive">
                                <table class="table table-hover table-bordered datatable">
                                    <thead class="thead-default">
                                        <tr>
                                            <th class="center">Date</th>
                                            <th class="center">Time</th>
                                            <th class="center">Bill No</th>
                                            <th class="center">User</th>
                                            <th class="right">Value</th>
                                            <th class="right">Discount</th>
                                            <th class="right">Net Value</th>
                                            <th class="right">Tax</th>
                                            <th class="right">Value with Tax</th>
                                            <th class="center">Order Type</th>
                                            <th class="center">MOP</th>
                                            <th class="center">Status</th>
                                            <th class="center">Customer</th>
                                        </tr>
                                    </thead>
                                    @if(isset($reports1) && !empty($reports1))
                                    <tbody>
                                        @php
                                        $r1_total_value = 0;
                                        $r1_total_discount = 0;
                                        $r1_total_net_value = 0;
                                        $r1_total_tax = 0;
                                        $r1_total_tax_and_value = 0;
                                        @endphp

                                        @foreach($reports1 as $row)
                                        <tr>
                                            <td class="center">{{date("d-M-Y", strtotime($row->date))}}</td>
                                            <td class="center">{{date("h:i A", strtotime($row->bill_time))}}</td>
                                            <td class="center">{{$row->bill_no}}</td>
                                            <td class="center">{{$row->cashier}}</td>
                                            <td class="right">{{$row->value}}</td>
                                            <td class="right">{{$row->discount}}</td>
                                            <td class="right">{{$row->net_value}}</td>
                                            <td class="right">{{$row->tax}}</td>
                                            <td class="right">{{$row->value+$row->tax}}</td>
                                            <td class="center">{{$row->order_type}}</td>
                                            <td class="center">{{$row->mop}}</td>
                                            <td class="center">
                                                @if($row->bill_status == 0) 
                                                Placed 
                                                @elseif($row->bill_status == 1)
                                                Accept
                                                @elseif($row->bill_status == 2)
                                                Decline
                                                @elseif($row->bill_status == 3)
                                                Pending
                                                @elseif($row->bill_status == 4)
                                                Delivered
                                                @elseif($row->bill_status == 5)
                                                Paid
                                                @endif
                                            </td>
                                            <td class="center">{{ucwords($row->name)}}</td>
                                        </tr>
                                        @php
                                        $r1_total_value += $row->value;
                                        $r1_total_discount += $row->discount;
                                        $r1_total_net_value += $row->net_value;
                                        $r1_total_tax += $row->tax;
                                        $r1_total_tax_and_value += $row->value+$row->tax;
                                        @endphp
                                        @endforeach
            
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                            <td class="right"></td>
                                            <td class="right"><b>{{$r1_total_value}}</b></td>
                                            <td class="right"><b>{{$r1_total_discount}}</b></td>
                                            <td class="right"><b>{{$r1_total_net_value}}</b></td>
                                            <td class="right"><b>{{$r1_total_tax}}</b></td>
                                            <td class="right"><b>{{$r1_total_tax_and_value}}</b></td>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                        </tr>
                                    </tfoot>
                                    @endif
                                </table>
                            </div>
                        </div>
                    </div>

                    <!-- item -->
                    <div class="card-header">
                        <h4 class="card-title">Category/Item</h4>
                        <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                        <div class="heading-elements">
                        </div>
                    </div>

                    <div class="row" id="" style="margin-top:20px;">
                        <div class="col-sm-12">
                            <div class="card-box table-responsive">
                                <table class="table table-hover table-bordered datatable">
                                    <thead class="thead-default">
                                        <tr>
                                            <th class="center">Date</th>
                                            <th class="center">User</th>
                                            <th class="center">Bill No</th>
                                            <th class="center">Item Category</th>
                                            <th class="center">Item Name</th>
                                            <th class="right">Qty</th>
                                            <th class="right">Value</th>
                                            <th class="right">Discount</th>
                                            <th class="center">Net Value</th>
                                            <th class="center">Order Type</th>
                                            <th class="center">MOP</th>
                                        </tr>
                                    </thead>
                                    @if(isset($reports2) && !empty($reports2))
                                    <tbody>
                                        @php
                                        $r2_total_quantity = 0;
                                        $r2_total_value = 0;
                                        $r2_total_discount = 0;
                                        $r2_total_net_value = 0;
                                        $r2_total_tax = 0;
                                        $r2_total_tax_and_value = 0;
                                        @endphp
                                        
                                        @foreach($reports2 as $row)
                                        <tr>
                                            <td class="center">{{date("d-M-Y", strtotime($row->date))}}</td>
                                            <td class="center">{{$row->cashier}}</td>
                                            <td class="center">{{$row->bill_no}}</td>
                                            <td class="center">{{$row->item_category}}</td>
                                            <td class="center">{{$row->item_name}}</td>
                                            <td class="right">{{$row->quantity}}</td>
                                            <td class="right">{{$row->value}}</td>
                                            <td class="right">{{$row->discount}}</td>
                                            <td class="right">{{$row->net_value}}</td>
                                            <td class="center">{{$row->order_type}}</td>
                                            <td class="center">{{$row->mop}}</td>
                                        </tr>
                                        @php
                                        $r2_total_quantity += $row->quantity;
                                        $r2_total_value += $row->value;
                                        $r2_total_discount += $row->discount;
                                        $r2_total_net_value += $row->net_value;
                                        @endphp
                                        @endforeach
                                        
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                            <td class="right"></td>
                                            <td class="right"></td>
                                            <td class="right"></td>
                                            <td class="right"><b>{{$r2_total_quantity}}</b></td>
                                            <td class="right"><b>{{$r2_total_value}}</b></td>
                                            <td class="right"><b>{{$r2_total_discount}}</b></td>
                                            <td class="right"><b>{{$r2_total_net_value}}</b></td>
                                            <td class="center"></td>
                                            <td class="center"></td>
                                        </tr>
                                    <tfoot>
                                    </tfoot>
                                    @endif
                                </table>
                            </div>
                        </div>
                    </div>

                    <!-- order type -->
                    <div class="card-header">
                        <h4 class="card-title">Order Type</h4>
                        <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                        <div class="heading-elements">
                        </div>
                    </div>
                    <div class="row" id="" style="margin-top:20px;">
                        <div class="col-sm-12">
                            <div class="card-box table-responsive">
                                <table class="table table-hover table-bordered datatable">
                                    <thead class="thead-default">
                                        <tr>
                                            <th class="center"><strong>Order Type</strong></th>
                                            <th class="right"><strong>Sale</strong></th>
                                            <th class="right"><strong>Discount</strong></th>
                                            <th class="right"><strong>Tax</strong></th>
                                            <th class="right"><strong>Delivery Charges</strong></th>
                                            <th class="right"><strong>Net Sale</strong></th>
                                        </tr>
                                    </thead>
                                    @if(isset($order_type) && !empty($order_type))
                                    <tbody>

                                        @php
                                        $ot_total_sale = 0;
                                        $ot_total_discount = 0;
                                        $ot_total_tax = 0;
                                        $ot_total_delivery_charges = 0;
                                        $ot_total_netsale = 0;
                                        @endphp
                                        
                                        @foreach($order_type as $row)
                                        <tr>
                                            <td class="center">{{ $row->order_type }} </td>
                                            <td class="right">{{ round($row->sale) }}</td>
                                            <td class="right">{{ round($row->discount) }}</td>
                                            <td class="right">{{ round($row->tax) }}</td>
                                            <td class="right">{{ round($row->delivery_charges) }}</td>
                                            <td class="right">{{ round($row->netsale) }}</td>
                                        </tr>
                                            @php
                                                $ot_total_sale += $row->sale;
                                                $ot_total_discount += $row->discount;
                                                $ot_total_tax += $row->tax;
                                                $ot_total_delivery_charges += $row->delivery_charges;
                                                $ot_total_netsale += $row->netsale;
                                            @endphp
                                        @endforeach

                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="center"></td>
                                            <td class="right"><b>{{ round($ot_total_sale) }}</b></td>
                                            <td class="right"><b>{{ round($ot_total_discount) }}</b></td>
                                            <td class="right"><b>{{ round($ot_total_tax) }}</b></td>
                                            <td class="right"><b>{{ round($ot_total_delivery_charges) }}</b></td>
                                            <td class="right"><b>{{ round($ot_total_netsale) }}</b></td>
                                        </tr>
                                    </tfoot>
                                    @endif
                                </table>
                            </div>
                        </div>
                    </div>

                    <!-- payment type -->
                    <div class="card-header">
                        <h4 class="card-title">Payment Type</h4>
                        <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                        <div class="heading-elements">
                        </div>
                    </div>
                    <div class="row" id="" style="margin-top:20px;">
                        <div class="col-sm-12">
                            <div class="card-box table-responsive">
                                <table class="table table-hover table-bordered datatable">
                                    <thead class="thead-default">
                                        <tr>
                                            <th class="center"><strong>Payment Type</strong></th>
                                            <th class="right"><strong>Sale</strong></th>
                                            <th class="right"><strong>Discount</strong></th>
                                            <th class="right"><strong>Tax</strong></th>
                                            <th class="right"><strong>Delivery Charges</strong></th>
                                            <th class="right"><strong>Net Sale</strong></th>
                                        </tr>
                                    </thead>
                                    @if(isset($payment_type) && !empty($payment_type))
                                    <tbody>

                                        @php
                                        $pm_total_sale = 0;
                                        $pm_total_discount = 0;
                                        $pm_total_tax = 0;
                                        $pm_total_delivery_charges = 0;
                                        $pm_total_netsale = 0;
                                        @endphp

                                        @foreach($payment_type as $row)
                                        <tr>
                                            <td class="center">{{ $row->payment_type }} </td>
                                            <td class="right">{{ round($row->sale) }}</td>
                                            <td class="right">{{ round($row->discount) }}</td>
                                            <td class="right">{{ round($row->tax) }}</td>
                                            <td class="right">{{ round($row->delivery_charges) }}</td>
                                            <td class="right">{{ round($row->netsale) }}</td>
                                        </tr>
                                            @php
                                                $pm_total_sale += $row->sale;
                                                $pm_total_discount += $row->discount;
                                                $pm_total_tax += $row->tax;
                                                $pm_total_delivery_charges += $row->delivery_charges;
                                                $pm_total_netsale += $row->netsale;
                                            @endphp
                                        @endforeach

                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="center"></th>
                                            <td class="right"><b>{{ round($pm_total_sale) }}</b></td>
                                            <td class="right"><b>{{ round($pm_total_discount) }}</b></td>
                                            <td class="right"><b>{{ round($pm_total_tax) }}</b></td>
                                            <td class="right"><b>{{ round($pm_total_delivery_charges) }}</b></td>
                                            <td class="right"><b>{{ round($pm_total_netsale) }}</b></td>
                                        </tr>
                                    </tfoot>
                                    @endif
                                </table>
                            </div>
                        </div>
                    </div>

                    <!-- platform -->
                    <div class="card-header">
                        <h4 class="card-title">Platform</h4>
                        <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                        <div class="heading-elements">
                        </div>
                    </div>
                    <div class="row" id="" style="margin-top:20px;">
                        <div class="col-sm-12">
                            <div class="card-box table-responsive">
                                <table class="table table-hover table-bordered datatable">
                                    <thead class="thead-default">
                                        <tr>
                                            <th class="center"><strong>Platform Name</strong></th>
                                            <th class="right"><strong>Sale</strong></th>
                                            <th class="right"><strong>Discount</strong></th>
                                            <th class="right"><strong>Tax</strong></th>
                                            <th class="right"><strong>Delivery Charges</strong></th>
                                            <th class="right"><strong>Net Sale</strong></th>
                                        </tr>
                                    </thead>
                                    @if(isset($platform) && !empty($platform))
                                    <tbody>

                                        @php
                                        $pf_total_sale = 0;
                                        $pf_total_discount = 0;
                                        $pf_total_tax = 0;
                                        $pf_total_delivery_charges = 0;
                                        $pf_total_netsale = 0;
                                        @endphp

                                        @foreach($platform as $row)
                                        <tr>
                                            <td class="center">{{ $row->platform }} </td>
                                            <td class="right">{{ round($row->sale) }}</td>
                                            <td class="right">{{ round($row->discount) }}</td>
                                            <td class="right">{{ round($row->tax) }}</td>
                                            <td class="right">{{ round($row->delivery_charges) }}</td>
                                            <td class="right">{{ round($row->netsale) }}</td>
                                        </tr>
                                            @php
                                                $pf_total_sale += $row->sale;
                                                $pf_total_discount += $row->discount;
                                                $pf_total_tax += $row->tax;
                                                $pf_total_delivery_charges += $row->delivery_charges;
                                                $pf_total_netsale += $row->netsale;
                                            @endphp
                                        @endforeach

                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td class="center"></td>
                                            <td class="right"><b>{{ round($pf_total_sale) }}</b></td>
                                            <td class="right"><b>{{ round($pf_total_discount) }}</b></td>
                                            <td class="right"><b>{{ round($pf_total_tax) }}</b></td>
                                            <td class="right"><b>{{ round($pf_total_delivery_charges) }}</b></td>
                                            <td class="right"><b>{{ round($pf_total_netsale) }}</b></td>
                                        </tr>
                                    </tfoot>
                                    @endif
                                </table>
                            </div>
                        </div>
                    </div>

                </div>
               
            </div>
            
        </div>
    </div>
</div>

@section('js')
<script src="{{asset('assets/admin/vendors/js/tables/jquery.dataTables.min.js')}}" type="text/javascript"></script>
<script src="{{asset('assets/admin/vendors/js/tables/datatable/dataTables.bootstrap4.min.js')}}" type="text/javascript"></script>
<script src="{{asset('assets/admin/vendors/js/tables/datatable/dataTables.buttons.min.js')}}" type="text/javascript"></script>
<script src="{{asset('assets/admin/js/scripts/tables/datatables/datatable-advanced.min.js')}}" type="text/javascript"></script>
<script src="{{asset('assets/admin/js/core/libraries/jquery_ui/jquery-ui.min.js')}}" type="text/javascript"></script>
<script src="{{asset('assets/admin/js/scripts/ui/jquery-ui/date-pickers.min.js')}}" type="text/javascript"></script>

<script type="text/javascript">
$(function(){
    $(".datepicker" ).datepicker({ dateFormat: 'yy-mm-dd' }).val();
    $(".datatable").DataTable({
        pageLength: '50',
    });
});
</script>
@endsection
@endsection