@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;
}
</style>
<div class="panel">
    <div class="container" style="width:100%;">
        <h1 align="center">Product Wise Report for {{date('d-M-Y', strtotime($date))}}</h1>
        <div style="overflow-x:auto;"> 
            <div id="example4_wrapper" class="dataTables_wrapper no-footer">
                <table width="90%" border="1" align="center" id="example4" class="dataTable no-footer" role="grid" aria-describedby="example4_info" style="width: 90%;">
                    <thead>
                        <tr role="row">
                            <th width="9%" rowspan="2" style="background-color: rgb(50, 131, 168); width: 80px;" colspan="1"  >
                                <div align="center"></div>
                            </th>
                            <th width="6%" rowspan="2" style="background-color: rgb(50, 131, 168); width: 29px;"  tabindex="0" aria-controls="example4" colspan="1" >
                                <div align="center" class="style2">Sr. No. </div>
                            </th>
                            <th width="25%" rowspan="2" style="background-color: rgb(50, 131, 168); width: 166px;"  tabindex="0" aria-controls="example4" colspan="1" >
                                <div align="center" class="style2">Product Group </div>
                            </th>
                            <th colspan="3" style="background-color:#3283a8;" rowspan="1">
                                <div align="center" class="style2">Total</div>
                            </th>
                            <th colspan="3" style="background-color:#3283a8;" rowspan="1">
                                <div align="center" class="style2">Dispatched</div>
                            </th>
                        </tr>
                        <tr role="row">
                            <th width="10%" style="background-color: rgb(50, 131, 168); width: 72px;"  tabindex="0" aria-controls="example4" rowspan="1" colspan="1" >
                                <div align="center" class="style2">Quantity</div>
                            </th>
                            <th width="10%" style="background-color: rgb(50, 131, 168); width: 56px;"  tabindex="0" aria-controls="example4" rowspan="1" colspan="1">
                                <div align="center" class="style2">Net in Rs </div>
                            </th>
                            <th width="10%" style="background-color: rgb(50, 131, 168); width: 64px;"  tabindex="0" aria-controls="example4" rowspan="1" colspan="1" >
                                <div align="center" class="style2">Gross Amt.</div>
                            </th>
                            <th width="10%" style="background-color: rgb(50, 131, 168); width: 72px;"  tabindex="0" aria-controls="example4" rowspan="1" colspan="1">
                                <div align="center" class="style2">Quantity</div>
                            </th>
                            <th width="10%" style="background-color: rgb(50, 131, 168); width: 56px;"  tabindex="0" aria-controls="example4" rowspan="1" colspan="1">
                                <div align="center" class="style2">Net in Rs </div>
                            </th>
                            <th width="10%" style="background-color: rgb(50, 131, 168); width: 64px;"  tabindex="0" aria-controls="example4" rowspan="1" colspan="1" >
                                <div align="center" class="style2">Gross Amt.</div>
                            </th>                            
                        </tr>
                    </thead>        
                    <tbody>
                        <tr role="row" class="even">
                            <td class="sorting_1">
                                         
                            </td>
                            <td><div align="center">1</div></td>
                            <td><div align="left">Grand Total</div></td>
                            <td><div align="center">{{DashBoardController::recivedOrder($date, 'qty')}}</div></td>
                            <td><div align="center">{{DashBoardController::recivedOrder($date, 'price')}}</div></td>
                            <td><div align="center">{{DashBoardController::recivedOrder($date, 'total_price')}}</div></td>
                            <td><div align="center">{{ DashBoardController::product_disptach_total_report($date, 'qty')}}</div></td>
                            <td><div align="center">{{DashBoardController::product_disptach_total_report($date, 'price')}}</div></td>
                            <td><div align="center">{{DashBoardController::product_disptach_total_report($date, 'total_price')}}</div></td>                           
                        </tr>
                        @php  $i=2; @endphp
                        @foreach($categories as $key => $category)
                       
                        <tr role="row" class="even">
                            <td class="sorting_1">
                                <div align="center">
                                    <a class="myButtonap"  href="{{ url('dashboard/daily/category/product/'. $category->id.'/'.$date) }}"> View </a>
                                </div>           
                            </td>
                            <td><div align="center">{{ ($i++) + ($categories->currentPage() - 1)*$categories->perPage() }}</div></td>
                            <td><div align="left">{{ucwords($category->name)}}</div></td>
                            <td><div align="center">{{ DashBoardController::product_report_total($date, 'qty',  $category->id) }}</div></td>
                            <td><div align="center">{{ DashBoardController::product_report_total($date, 'price',  $category->id) }}</div></td>
                            <td><div align="center">{{ DashBoardController::product_report_total($date, 'total_price',  $category->id) }}</div></td>
                            <td><div align="center">{{DashBoardController::product_disptach_report($date, 'qty',  $category->id)}}</div></td>
                            <td><div align="center">{{DashBoardController::product_disptach_report($date, 'price',  $category->id)}}</div></td>
                            <td><div align="center">{{DashBoardController::product_disptach_report($date, 'total_price',  $category->id)}}</div></td>                           
                        </tr>
                        @endforeach
                   </tbody>
                </table>
                {{ $categories->appends(request()->input())->links() }}
            </div> 
        </div>
    </div>
    <script type="text/javascript">
        function show_product_details(id, date){
            $.post('{{ url('dashboard/daily/category/product/id/date') }}',{_token:'{{ @csrf_token() }}'}, function(data){
                $('#awb_modal #modal-content').html(data);
                $('#awb_modal').modal('show', {backdrop: 'static'});
            });
        }
    </script>
@endsection