@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')
<div class="card sina-card">
    <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <h4 class="col-6">Order Analysis</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"> 
    <form action="{{  Request::url() }}" method="get">
        <div class="row pb-3">
            <div class="col-3">
                
            </div>
            <div class="col-3">
                
            </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-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>
    </form>
@if(count($orders))
            <div class="table-responsive" id="divTableDataHolder">
                @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 STORE';
                    $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">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Store</th>
                            <th>Date</th>
                            <th>Dealer</th>
                            <th>Group</th>
                            <th>Limit</th>
                            <th>Amount</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody id="tbl_body_index">
                        <input type="hidden" id="blade_type" value="{{$blade_type}}">
                        @php
                            $total=0;
                            $p=1;
                            $action_id=801;
                            $isOrderShowedShopWise=[];
                        @endphp
                        @forelse (Request()->shop_id?$shops->where('id',Request()->shop_id):$shops as $key=>$zone)
                            @php
                                $wareAmount=0;
                                $zone_group=array_filter(explode(',',($zone->officer?$zone->officer->group_ids:null)));
                                $parties=$showroom->whereIn('group_id',$zone_group)->pluck('id')->toArray();
                                $parties=array_merge($parties,$showroom->where('id',$zone->party_id)->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
                             <tr><td class="text-left text-dark" colspan="8"><strong>{{strtoupper($zone->name)}}</strong></td></tr>
                            @forelse ($transactions as $i=>$item)
                                
                                <tr id="tr{{$p}}">
                                    <td> {{ ($p++) }}</td>
                                    <td>
                                        {{ $warehouses->where('id',$item->warehouse_id)->first()->name_eng }}
                                    </td>
                                    <td>
                                        {{ date('d-M-Y h:i A',strtotime($item->created_at)) }}
                                    </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>{{ $item->showroom?($item->showroom->limit_apply?$item->showroom->credit_limit_amount:'Not Apply'):'' }}</td>
                                    @php
                                        $details=$item->details;
                                        $netTotal=$details->sum(function($q){
                                            return ($q->order_price*$q->order_qty);
                                        });
                                        $wareAmount+=$netTotal
                                        // $wareAmount+=$item->net_total;
                                    @endphp
                                <td class="text-right" title="{{$item->net_total}}">{{ number_format($netTotal,2) }}</td>
                                    {{-- <td class="text-right">{{ number_format($item->net_total,2) }}</td> --}}
                                    <td class="text-left">
                                        <a href="{{route('order.print',['id'=>$item->id])}}" target="_blank" type="button" class="btn btn-sm btn-info btn-hover" onclick="$('#btn_print_'+{{ $i }}).attr('class', 'btn btn-sm btn-warning btn-hover')" name="sell" id="btn_print_{{ $i }}">Print</a>
                                        @if ($item->delivery_status == 0 && get_guard()=='admin')
                                            @if(checkAuthPermission('order.edit'))
                                                <a href="{{route('order.edit',['id'=>$item->id,'marketing'=>1])}}" target="_blank" type="button" class="btn btn-sm btn-dark btn-hover" name="sell">Edit</a>
                                            @endif
                                        @endif
                                    </td>
                                </tr>
                            @empty
                            @endforelse {{-- $transactions --}}
                            @php $total+=$wareAmount; @endphp
                            <tr><td class="text-right text-dark" colspan="6"><strong>{{'Total : '}}</strong></td><td class="text-right"><strong>{{number_format($wareAmount,2)}}</strong></td><td></td></tr>
                        @empty 
                        @endforelse {{-- $warehouse --}}
                        <tr><td class="text-center text-dark" colspan="6"><strong>{{'Grand Total'}}</strong></td><td class="text-right"><strong>{{number_format($total,2)}}</strong></td><td></td></tr>
                    </tbody>
                </table>
                
            </div>
@endif           
    </div>
</div>
@include('inventory.order.detail_modal')
@endsection
@section('script')

<script>
    $(document).ready(function(){
        $('.select_2').select2();
        $('#save').hide();
    })
    function showDetails(data){
          var bladeType=$('#blade_type').val();
          if(bladeType==2){
              $('#order_no').val(data.order_no);
              $('#order_id').val(data.id);
              $('#invoice_no').val(data.transactions.length>0?data.transactions[0].autocode_before_bill:data.fg_transactions[0].autocode_before_bill);
          }
        $("#order_details_modal").modal("hide");
            var str ='';
            console.log(data);
        //    $('#recipe_id').val(data.recipe_id);
        //    $('#indent_id').val(data.id);
        //    $('#b_qty').val(data.indent_qty);
        //    $('#finished_product').html(
        //     `<option value=`+data.product_id+`>`+data.product.name_eng+`</option>`
        //    );
            //    $('#finished_product').val(data.name);
            // rawData=data.transactions;
            var rawData=[];
            if(data.transactions.length>0){
                rawData=data.transactions;
            }else if(data.fg_transactions.length>0){
                rawData=data.fg_transactions;
            }else{
                rawData=data.details;
            }
                    if(rawData.length>0){
                        for (let index = 0; index < rawData.length; index++) {
                             str += `<tr id="tr`+index+`">
                                <td>`+(index+1)+`</td>
                                <td>`+rawData[index].product.name_local+` (`+rawData[index].product.name_eng+`)</td>
                                <td>`+rawData[index].order_qty+`</td>`;
                                str += `<td>`+rawData[index].quantity+`</td>`;
                                if(bladeType==2){
                                    str += `
                                <td>`+rawData[index].allocated_qty+`</td>
                                <td><input type="number" name="quantity[`+rawData[index].id+`]" value="`+rawData[index].allocated_qty+`"></td>`;
                                }
                                str += `</tr>`;
                            temp=(index+2);
                        }
    
                    }
                   
                    $('#tbl_body').html(str);
                    $("#order_details_modal").modal("show");
                    //initSelect2();
    }
function updateBtn(row_id){
    var checked=$('#check'+row_id).is(':checked');
    //alert(checked);
    if(checked){
        $('#update_btn'+row_id).show('slow');
    }else{
        $('#update_btn'+row_id).hide('slow');
    }
}
function setIndent(){
        var voucher_ids = [];
        $.each($("input[name='voucher_to_set_preparation']:checked"), function(){
            voucher_ids.push($(this).val());
        });
        if(voucher_ids.length>0){
            var url="{{route('indent.create')}}";
            url+="?order_id="+voucher_ids.toString();
            //alert(url);
            location.href=url;
        }else{
            alert('Please Select Order');
        }
    }
function setAllChecked(elementBox){
    if(elementBox.checked) {
        $('.voucher_to_set_preparation').prop("checked", true);
    }else{
        $('.voucher_to_set_preparation').prop("checked", false);
    }
}
function updateApproveStatus(row_id,action_step_id,model_name,cost_center_id){
    //alert(model_name);
    if(confirm('are you sure?')){
        $.ajax({
                type: "GET",
                url: "{{route('costcenter_mapping.update_approval_log')}}",
                data: {
                    approvable_id:row_id,
                    approvable_type:model_name,
                    action_step_id:action_step_id,
                    cost_center_id:cost_center_id,
                },
                success: function (data) {
                location.reload();
                },
                error: function (response) {
                },
        });
    }
}
function setApproved(order_id,status){
    if(confirm('are you sure?')){
        $.ajax({
                type: "GET",
                url: "/manage-delivery-list",
                data: {
                    order_id:order_id,
                    type:4,
                    status:status
                },
                success: function (data) {
                location.reload();
                },
                error: function (response) {
                },
            });
        }
}
function selectAllChild(t){
    if(t.checked) {
        $('.vh').prop("checked", true);
       
    }else{
        $('.vh').prop("checked", false);
    }
    if($('.vh:checkbox:checked').length>0){
        $('#save').show();
    }else{
        $('#save').hide();
    }
}

function showDeliveryBtn(t){
    if(t.checked) {
        $('#save').show();
    }else{
        if($('.vh:checkbox:checked').length>0){
            $('#save').show();
        }else{
            $('#save').hide();
        }
    }
}

$(document).ready(function() {
        $('#datatable_apply').dataTable({
            "paging": false,
            "columnDefs": [ {
                "orderable": false,
                'targets': 0,
            } ]
        });
    });
</script>
@stop