@extends('admin.layout.master')
@section('title','ORDER SHEET')
@section('custom_style')
    <style>
        /* input[type=text],
        input[type=file],
        input[type=number] {
            height: 35px !important;
        } */
        .table th, .table td {
            padding: 0px 5px;
            color: black;
        }
        .table th {
            background: #ab3535;
            padding: 5px !important;
            color: white !important;
        }
        .table-bordered th, .table-bordered td {
            border: 1px solid #c1c1c1 !important;
        }
        .special-cell{
            background: #bfbfbf;
            padding: 5px !important;
            color: black !important;
        }
        .btn-sina-submit {
                position: fixed;
                bottom:15%;
                right:2px;
            }
        @media only screen and (max-width: 620px) {
            .btn-sina-submit {
                position: fixed;
                min-width: 100%;
                bottom:0;
                right:0;
            }
        }
        .btn-sm{
            padding: 0 0.25rem !important;
        }
        input[type="checkbox"]:checked ~ label:before {background: #20bf6b no-repeat center; background-size: 12px 12px; background-image: url(data:image/svg+xml;utf8;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iaXNvLTg4NTktMSI/Pgo8IS0tIEdlbmVyYXRvcjogQWRvYmUgSWxsdXN0cmF0b3IgMTYuMC4wLCBTVkcgRXhwb3J0IFBsdWctSW4gLiBTVkcgVmVyc2lvbjogNi4wMCBCdWlsZCAwKSAgLS0+CjwhRE9DVFlQRSBzdmcgUFVCTElDICItLy9XM0MvL0RURCBTVkcgMS4xLy9FTiIgImh0dHA6Ly93d3cudzMub3JnL0dyYXBoaWNzL1NWRy8xLjEvRFREL3N2ZzExLmR0ZCI+CjxzdmcgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiB4bWxuczp4bGluaz0iaHR0cDovL3d3dy53My5vcmcvMTk5OS94bGluayIgdmVyc2lvbj0iMS4xIiBpZD0iQ2FwYV8xIiB4PSIwcHgiIHk9IjBweCIgd2lkdGg9IjE2cHgiIGhlaWdodD0iMTZweCIgdmlld0JveD0iMCAwIDQ1LjcwMSA0NS43IiBzdHlsZT0iZW5hYmxlLWJhY2tncm91bmQ6bmV3IDAgMCA0NS43MDEgNDUuNzsiIHhtbDpzcGFjZT0icHJlc2VydmUiPgo8Zz4KCTxnPgoJCTxwYXRoIGQ9Ik0yMC42ODcsMzguMzMyYy0yLjA3MiwyLjA3Mi01LjQzNCwyLjA3Mi03LjUwNSwwTDEuNTU0LDI2LjcwNGMtMi4wNzItMi4wNzEtMi4wNzItNS40MzMsMC03LjUwNCAgICBjMi4wNzEtMi4wNzIsNS40MzMtMi4wNzIsNy41MDUsMGw2LjkyOCw2LjkyN2MwLjUyMywwLjUyMiwxLjM3MiwwLjUyMiwxLjg5NiwwTDM2LjY0Miw3LjM2OGMyLjA3MS0yLjA3Miw1LjQzMy0yLjA3Miw3LjUwNSwwICAgIGMwLjk5NSwwLjk5NSwxLjU1NCwyLjM0NSwxLjU1NCwzLjc1MmMwLDEuNDA3LTAuNTU5LDIuNzU3LTEuNTU0LDMuNzUyTDIwLjY4NywzOC4zMzJ6IiBmaWxsPSIjRkZGRkZGIi8+Cgk8L2c+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPGc+CjwvZz4KPC9zdmc+Cg==);}
    </style>
@endsection
@section ('content')
<form action="{{  Request::url() }}" method="get">
<div class="card sina-card">
    <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <h4 class="col-6">Order Sheet</h4>
        <div class="col-6 d-flex justify-content-end">
            <button id="myButtonControlID" class="btn-sina-title-add d-flex align-items-center" type="button" name="button">
                <div class=""> Excel </div>
                <div class="col pl-2 pr-0">
                    <i class="fa fa-download"></i>
                </div>
            </button>
            &nbsp;
            <button class="btn-sina-title-add d-flex align-items-center" type="button" name="button" onclick="PrintDiv()">
                <div class=""> Print </div>
                <div class="col pl-2 pr-0">
                    <i class="fa fa-print"></i>
                </div>
            </button>
        </div>
    </div>
    <div class="card-body pt-1"> 
                    <div class="row pb-3">
                        <div class="col-3">
                            {{-- <label for="shop_id">{{ (marketing_customer() && marketing_customer()->level>4)?'Zone':'Region' }}</label>
                            <select class="select_2" style="width: 100%" name="shop_id" id="shop_id">
                                <option value=""> --Select-- </option>
                                @forelse ($shops as $shop)
                                    <option @if(Request()->shop_id==$shop->id) selected="selected" @endif value="{{ $shop->id }}"> {{ $shop->name }}</option>
                                @empty
                                    
                                @endforelse
                            </select> --}}
                        </div>
                        <div class="col-3">
                            {{-- <label for="showroom_id">Dealer</label>
                            <select class="select_2" style="width: 100%" name="showroom_id" id="showroom_id">
                                <option value=""> --Select-- </option>
                                @forelse ($showroom as $item)
                                    <option @if(Request()->showroom_id==$item->id) selected="selected" @endif value="{{ $item->id }}"> {{ $item->name_eng }}</option>
                                @empty
                                    
                                @endforelse
                            </select> --}}
                        </div>
                        <div class="col-2">
                            <label for="warehouse_id">Store</label>
                            <select class="select_2" style="width: 100%" name="warehouse_id" id="warehouse_id">
                                <option value=""> --Select-- </option>
                                @forelse ($warehouses as $item)
                                    <option @if(Request()->warehouse_id==$item->id) selected="selected" @endif value="{{ $item->id }}"> {{ $item->name_eng }}</option>
                                @empty
                                    
                                @endforelse
                            </select>
                        </div>
                        {{-- <div class="col-2">
                            <label for="status">Status</label>
                            <select class="select_2" style="width: 100%" name="status" id="status">
                                <option value="500" @if(Request()->status==500) selected="selected" @endif> Ordered</option>
                                <option value="0" @if(Request()->status==0) selected="selected" @endif> Pending </option>
                                <option value="1" @if(Request()->status==1) selected="selected" @endif> Rejected </option>
                                <option value="2" @if(Request()->status==2) selected="selected" @endif> Delivered </option>
                            </select>
                        </div> --}}
                       
                        <div class="col-4">
                            <label for="status">Date</label>
                            <div class="input-group-append">
                                <input type="date" class="form-control bsdatepicker" id="date_from" name="date_from" value="{{Request()->date_from?date('Y-m-d',strtotime(Request()->date_from)):date('Y-m-d')}}">
                                <label class="input-group-text" style="height: 28px; margin-left: -2px; margin-right: -2px">To</label>
                                <input type="date" class="form-control bsdatepicker" id="date_to" name="date_to" value="{{Request()->date_to?date('Y-m-d',strtotime(Request()->date_to)):date('Y-m-d')}}"> 
                                <button type="submit" style="height: 28px; margin-left: -2px" class="btn btn-sm btn-hover btn-danger">
                                    <i class="fa fa-search"></i>
                                </button>
                            </div>
                        </div>
                    </div>
                {{-- </div> --}}
            </form>
@if(count($orders))
            <div id="divTableDataHolder">
            <div class="table-responsive">
                @php
                    $printData['start_date']=Request()->date_from?date('d-M-Y',strtotime(Request()->date_from)):date('d-M-Y');
                    $printData['end_date']=Request()->date_to?date('d-M-Y',strtotime(Request()->date_to)):date('d-M-Y');
                    $printData['warehouse']=Request()->warehouse_id && Request()->warehouse_id!=0?$warehouses->where('id',Request()->warehouse_id)->first()->name_eng:'All Showroom';
                    $routeName=Route::currentRouteName();   
                    $printData=getPrintData($routeName,$printData);
                @endphp
                <style type="text/css">{!!$printData['style_css']!!}</style>
                {!!$printData['head']!!}
                <table class="table table-bordered table-hover" id="datatable_apply_o">
                    <thead>
                        @php
                            $th='';
                            $th1='';
                            $colspan=1;
                            $rowspan=2;
                            foreach($categories as $cc=>$subCategory){
                                $cat_sub_total[$subCategory->id]=0;
                                $cat_sub_amountTotal[$subCategory->id]=0;
                                if($rowspan==2){
                                    $colspan=count($subCategory->product);
                                    $th1.='<th colspan="'.($colspan+1).'" class="text-center catcode_th" style="background-color:#002952">'.$subCategory->name_eng.'</th>';
                                }
                                foreach ($subCategory->product as $k=>$product){
                                    $pro_sub_total[$product->id]=0;
                                    // $c_pro_sub_total[$product->id]=0;
                                    $th.='<th class="text-center catcode_th">'.$product->short_name.'</th>';
                                }
                                $th.='<th class="text-center catcode_th bg-warning">'.($rowspan==2?'Total':$subCategory->name_eng).'</th>';
                            }
                        @endphp
                        <tr>
                            <th rowspan="{{$rowspan}}">#</th>
                            <th rowspan="{{$rowspan}}">Dealer</th>
                            <th rowspan="{{$rowspan}}">Group</th>
                            <th style="background-color: #002952" class="text-center"  colspan="{{2}}">Total</th>
                            {{-- <th>Details</th> --}}
                            {!!$rowspan==2?$th1:$th!!}
                        </tr>
                        @if($rowspan==2)
                        <tr>
                            <th style="background-color: #002952" class="text-center" >Qty</th>
                            <th style="background-color: #002952" class="text-center" >Amt</th>
                            {!!$th!!}
                        </tr>
                        @endif
                    </thead>
                    <tbody id="tbl_body_index">
                        <input type="hidden" id="blade_type" value="{{$blade_type}}">
                        @php
                            $p=1;
                            $action_id=801;
                            $isOrderShowedShopWise=[];
                        @endphp
                        @forelse (Request()->shop_id?$shops->where('id',Request()->shop_id):$shops as $key=>$zone)
                            @php
                                
                                $zone_group=array_filter(explode(',',($zone->officer?$zone->officer->group_ids:null)));
                                $parties=$showroom->whereIn('group_id',$zone_group)->pluck('id')->toArray();
                                if(count($parties)){
                                    $transactions=$orders->whereIn('party_id',$parties)->where('transaction_type',14);
                                    $isOrderShowedShopWise=array_merge($isOrderShowedShopWise,$transactions->pluck('id')->toArray());
                                }else{
                                    $transactions=[];
                                }
                            @endphp
                           @forelse ($transactions as $i=>$item)
                                @php
                                    $zonalTotal[$item->id]=0;
                                    $zonalTotalQty[$item->id]=0;
                                    $row='';
                                    foreach($categories as $cc=>$subCategory){
                                        $catAmount=0;
                                        $proWiseTotalAmount=0;
                                        foreach ($subCategory->product as $k=>$product){
                                            $productTrans=$item->details->where('product_id',$product->id);
                                            $catAmount+=$amt=(count($productTrans)?$productTrans->sum(function($q) {return ($q->order_qty/$q->unit_qty);}):0);
                                            // $catAmount+=$amt=(count($productTrans)?$productTrans->sum('order_qty'):0);
                                            $proWiseTotalAmount+=(count($productTrans)?$productTrans->sum(function($q) {return ($q->order_qty*$q->order_price);}):0);
                                            // $proWiseTotalAmount+=(count($productTrans)?$productTrans->sum(function($q) {return ($q->order_qty*$q->order_price*$q->unit_qty);}):0);
                                            $pro_sub_total[$product->id]+=$amt;
                                            $row.='<td class="text-right catcode_td">'.round($amt).'</td>';
                                            $zonalTotalQty[$item->id]+=$amt;
                                        }
                                        $zonalTotal[$item->id]+=$proWiseTotalAmount;
                                        $cat_sub_total[$subCategory->id]+=$catAmount;
                                        $cat_sub_amountTotal[$subCategory->id]+=$proWiseTotalAmount;
                                        $row.='<td class="text-right catcode_td bg-warning">'.round($catAmount).'</td>';
                                    }
                                @endphp
                                <tr id="tr{{$p}}">
                                    <td> {{ ($p++).'--'.$item->id }}</td>
                                    <td>
                                        {{ $item->showroom?$item->showroom->name_eng:'N\A' }}
                                    </td> 
                                    <td>{{ $item->showroom?($item->showroom->group_id?$groups->where('id',$item->showroom->group_id)->first()->name_eng:'no Group'):'' }}</td>
                                    <td class="text-right catcode_td" style="background-color: bisque">{{round($zonalTotalQty[$item->id])}}</td>
                                    <td class="text-right catcode_td" style="background-color: bisque">{{round($zonalTotal[$item->id])}}</td>
                                    {!!$row!!}
                                </tr>
                                @empty
                                @endforelse {{-- $transactions --}}
                        @empty 
                        @endforelse {{-- $shops --}}
                        @php
                            $transactions=$orders->whereNotIn('id',$isOrderShowedShopWise)->where('transaction_type',14);
                        @endphp
                        {{-- IF NOT RM WISE --}}
                        @forelse ($transactions as $i=>$item)
                                @php
                                    $row='';
                                    $zonalTotal[$item->id]=0;
                                    $zonalTotalQty[$item->id]=0;
                                    foreach($categories as $cc=>$subCategory){
                                        $catAmount=0;
                                        $proWiseTotalAmount=0;
                                        foreach ($subCategory->product as $k=>$product){
                                            $productTrans=$item->details->where('product_id',$product->id);
                                            $catAmount+=$amt=(count($productTrans)?$productTrans->sum(function($q) {return ($q->order_qty/$q->unit_qty);}):0);
                                            // $catAmount+=$amt=(count($productTrans)?$productTrans->sum('order_qty'):0);
                                            $proWiseTotalAmount+=(count($productTrans)?$productTrans->sum(function($q) {return ($q->order_qty*$q->order_price);}):0);
                                            // $proWiseTotalAmount+=(count($productTrans)?$productTrans->sum(function($q) {return ($q->order_qty*$q->order_price*$q->unit_qty);}):0);
                                            $pro_sub_total[$product->id]+=$amt;
                                            $row.='<td class="text-right catcode_td">'.round($amt).'</td>';
                                            $zonalTotalQty[$item->id]+=$amt;
                                        }
                                        $zonalTotal[$item->id]+=$proWiseTotalAmount;
                                        $cat_sub_total[$subCategory->id]+=$catAmount;
                                        $cat_sub_amountTotal[$subCategory->id]+=$proWiseTotalAmount;
                                        $row.='<td class="text-right catcode_td bg-warning">'.round($catAmount).'</td>';
                                    }
                                @endphp
                                <tr id="tr{{$p}}">
                                    <td> {{ ($p++) }}</td>
                                    <td>
                                        {{ $item->showroom?$item->showroom->name_eng:'N\A' }}
                                    </td> 
                                    <td>{{ $item->showroom?($item->showroom->group_id?$groups->where('id',$item->showroom->group_id)->first()->name_eng:'no Group'):'' }}</td>
                                    <td class="text-right catcode_td" style="background-color: bisque">{{round($zonalTotalQty[$item->id])}}</td>
                                    <td class="text-right catcode_td" style="background-color: bisque">{{round($zonalTotal[$item->id])}}</td>
                                    {!!$row!!}
                                </tr>
                            @empty
                            @endforelse
                            @php
                            $row='';
                            foreach($categories as $cc=>$subCategory){
                                foreach ($subCategory->product as $k=>$product){
                                    $amt=$pro_sub_total[$product->id];
                                    $row.='<td class="text-right catcode_td">'.round($amt).'</td>';
                                }
                                $catAmount=$cat_sub_total[$subCategory->id];
                                $row.='<td class="text-right catcode_td bg-warning">'.round($catAmount).'</td>';
                            }
                        @endphp
                            <tr>
                    
                                <td colspan="3" class="text-right">
                                    {{ 'TOTAL' }}
                                </td>
                                <td class="text-right catcode_td" style="background-color: bisque">{{round(array_sum($zonalTotalQty))}}</td> 
                                <td class="text-right catcode_td" style="background-color: bisque">{{round(array_sum($zonalTotal))}}</td> 
                                {!!$row!!}
                            </tr>
                    </tbody>
                </table>
            </div>
            <div class="table-responsive">
                <table class="table table-bordered table-hover">
                    <thead>
                        <tr><th class="text-center" colspan="{{count($categories)+2}}">CATEGORY WISE ORDER SHEET</th></tr>
                        <tr>
                            <th>Category</th>
                            @forelse($categories as $cc=>$subCategory)
                                <th colspan="1" class="text-center catcode_th">{{$subCategory->name_eng}}</th>
                            @empty
                            @endforelse
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <th>Qty</th>
                            @forelse($categories as $cc=>$subCategory)
                                <td colspan="1" class="text-center catcode_th"><strong>{{round($cat_sub_total[$subCategory->id])}}</strong></td>
                            @empty
                            @endforelse
                            <th>{{round(array_sum($cat_sub_total))}}</th>
                        </tr>
                        <tr>
                            <th>Amount</th>
                            @forelse($categories as $cc=>$subCategory)
                                <td colspan="1" class="text-center catcode_th"><strong>{{round($cat_sub_amountTotal[$subCategory->id])}}</strong></td>
                            @empty
                            @endforelse
                            <th>{{round(array_sum($cat_sub_amountTotal))}}</th>
                        </tr>
                    </tbody>
                </table>
            </div>
            </div>
@endif           
        {{-- </form> --}}
    </div>
</div>
</form>
@include('inventory.order.detail_modal')
@endsection
@section('script')

<script>
    $(document).ready(function(){
        $('.select_2').select2();
        $('#save').hide();
    });



$(document).ready(function() {
    $('.text-right').each(function() {
            var cellText = $(this).text();
            if(cellText=='0'){
                $(this).html(' ');
                $(this).attr('class', 'text-center');
            }
        });
        $('#datatable_apply').dataTable({
            "paging": false,
            "columnDefs": [ {
                "orderable": false,
                'targets': 0,
            } ]
        });
    });
</script>
@stop