@extends('layouts.app')
@section('content')
<style type="text/css">
.text-main, a.text-main:hover, a.text-main:focus {
    color: #f5f5f5;
    font-weight: 700;
}
.text-3x {
    font-size: 2.5em;
}
nav{ float:right; margin-top: -18px; margin-bottom: 40px; }
</style>
<div class="row">
	<div class="panel">
    <table align="center" id="customa">
        <thead>
            <tr>
                <th style="background-color:#3283a8;" width="8%" rowspan="3"><div align="center">Sr No.</div></th>
                <th style="background-color:#3283a8;" width="12%" rowspan="3"><div align="center">Date</div></th>
                
                <th style="background-color:#3283a8;" colspan="12"><div align="center">Order Status </div></th>
            </tr>
            <tr>
                <th style="background-color:#3283a8;" colspan="4"><div align="center">Received</div></th>
                <th style="background-color:#3283a8;" colspan="4"><div align="center">Delivered</div></th>
          
            </tr>
            <tr>
                <th style="background-color:#3283a8;" width="6%"><div align="center">No</div></th>
                <th style="background-color:#3283a8;" width="7%"><div align="center">Qty</div></th>
                <th style="background-color:#3283a8;" width="8%"><div align="center">Net in Rs. </div></th>
                <th style="background-color:#3283a8;" width="8%"><div align="center">Gross Amt. </div></th>
                <th style="background-color:#3283a8;" width="6%"><div align="center">No</div></th>
                <th style="background-color:#3283a8;" width="6%"><div align="center">Qty</div></th>
                <th style="background-color:#3283a8;" width="8%"><div align="center">Net in Rs. </div></th>
                <th style="background-color:#3283a8;" width="8%"><div align="center">Gross Amt. </div></th>              
            </tr>
        </thead>
        <tbody>
            <tr>
                <td><div align="center"><span class="style1">1</span></div></td>
                <td><div align="center"><span class="style1">TOTAL</span></div></td>
              
                <td><div align="center"><span class="style1">{{ \App\Order::where('payment_status', 'paid')->count() }}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('payment_status', 'paid')->where('delivery_status', '=', 'confirmed')->orwhere('delivery_status', '=', 'delivered')->orwhere('delivery_status', '=', 'on_review')->sum('quantity')}}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('payment_status', 'paid')->where('delivery_status', '=', 'confirmed')->orwhere('delivery_status', '=', 'delivered')->orwhere('delivery_status', '=', 'on_review')->sum('price') - \App\OrderDetail::where('payment_status', 'paid')->sum('tax')}}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('payment_status', 'paid')->where('delivery_status', '=', 'confirmed')->orwhere('delivery_status', '=', 'delivered')->orwhere('delivery_status', '=', 'on_review')->sum('price')}}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('delivery_status', 'delivered')->count()}}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('delivery_status', 'delivered')->sum('quantity')}}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('delivery_status', 'delivered')->sum('price') - \App\OrderDetail::where('delivery_status', 'delivered')->sum('tax')}}</span></div></td>
                <td><div align="center"><span class="style1">{{\App\OrderDetail::where('delivery_status', 'delivered')->sum('price')}}</span></div></td>
               
            </tr>

            @php
            $i = 2; @endphp
            @foreach($response as $key => $val)
            @php $date = $val['date']; @endphp

            <tr>
                <td><div align="center">{{ ($i++) + ($response->currentPage() - 1)*$response->perPage() }}</div></td>
                <td><div align="center"><a href="{{route('category.daily', $date)}}">{{date('d-M-Y', strtotime($date))}}</a></div></td>
               
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::recivedOrder($date, 'count')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::recivedOrder($date, 'qty')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::recivedOrder($date, 'price')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{ DashBoardController::recivedOrder($date, 'total_price')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::deliveredOrder($date, 'count')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::deliveredOrder($date, 'qty')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::deliveredOrder($date, 'price')}}</span>
                    </div>
                </td>
                <td>
                    <div align="center">
                        <span class="style1">{{DashBoardController::deliveredOrder($date, 'total_price')}}</span>
                    </div>
                </td>        
            </tr> 
          @endforeach
        </tbody>
    </table>
    {{$response}}
</div>

</div>
@endsection