@extends('admin.layout.master')
@section('title','MARKETING ORDER '.($type==1?'RETURN':'').' LIST')
@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">
        <div class="d-flex">
            <h4 class="col-md-6">ORDER {{$type==1?'RETURN':''}} LIST</h4>
        </div>
        {{-- <button id="myButtonControlID" class="pull-right">Excel</button> --}}
    </div>
    <div class="card-body pt-1" id="divTableDataHolder"> 
        {{-- <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" /> --}}
        {{-- <div class="card-body pt-0"> --}}
            {{-- <form action="{{  Request::url() }}" method="get"> --}}
                {{-- <div class=""> --}}
                    <div class="row pb-3">
                        {{-- <div class="col-2">
                            <label for="order_no">Order No</label>
                            <input class="form-control" type="text" name="order_no" id="order_no">
                        </div> --}}
                        <div class="col-lg-2 col-sm-4 col-12">
                            <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-lg-2 col-sm-4 col-12">
                            <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-lg-2 col-sm-4 col-12">
                            <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-2">
                            <label for="shift">Shift</label>
                            <div class="form-group">
                                <select name="shift" id="shift" class="form-control select_2">
                                    <option value="0"  @if(Request()->shift==0) selected="selected" @endif> All </option>
                                    <option value="1"  @if(Request()->shift==1) selected="selected" @endif> Morning </option>
                                    <option value="2" @if(Request()->shift==2) selected="selected" @endif> Evening </option>
                                </select>
                            </div>
                        </div> --}}
                        {{-- <div class="col-3">
                            <label for="group">Group</label>
                            <div class="form-group">
                                <select class="select_2" style="width: 100%" name="group" id="group">
                                    <option value="500" @if(Request()->group==500) selected="selected" @endif> Not Apply </option>
                                    <option value="100" @if(Request()->group==100) selected="selected" @endif> All </option>
                                    @forelse (getAccountsGroup() as $grp)
                                    <option value="{{$grp->id}}" @if(Request()->group==$grp->id) selected="selected" @endif> {{$grp->name}}</option>
                                    @empty
                        
                                    @endforelse
                                </select>
                            </div>
                        </div> --}}
                        <div class="col-lg-5 col-sm-12 col-5">
                            <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>
        {{-- </div> --}}
        <form id="form" method="get" action="{{ route('sell.create') }}" name="form" enctype="multipart/form-data">
            @csrf
            <div class="table-responsive">
                {{-- <div class="input-group row justify-content-end">
                    <div class="input-group-append">
                        <button type="button" class="btn btn-sm btn-info" onclick="setIndent()">
                            <span class="fa fa-calendar"></span> Indent Product
                        </button>
                    </div>
                </div> --}}
                <table class="table table-bordered table-hover" id="datatable_apply">
                    {{-- @if(isMarketingEnable()==1 && Request()->status==0) <input type="hidden" name="party_id" value="{{Request()->showroom_id!=0?Request()->showroom_id:null}}"> @endif --}}
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Date</th>
                            <th>Order No</th>
                            <th>Dealer</th> 
                            {{-- <th>Order Type</th> --}}
                            {{-- <th>Group</th> --}}
                            <th>Store</th>
                            <th>Amount</th>
                            <th>Delivery</th>
                            <th>
                                <div class="form-check">
                                    <input class="form-check-input voucher_id_all" onclick="setAllCheckedApprovalbles(this)" type="checkbox" value="1" id="voucher_id_all">
                                    <label class="form-check-label" for="voucher_id_all">Approvals </label>
                                </div>
                            </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
                            {{-- style="background-color:#002952" --}}
                            <tr><td class="text-center text-dark" colspan="10" {{-- style="background-color:#002952" --}}><strong>{{$zone->name}}</strong></td></tr>
                            @forelse ($transactions as $i=>$item)
                            <tr id="tr{{$p}}">
                                <td> {{ ($p++) }}</td>
                                <td>
                                    {{ date('d-M-Y h:i A',strtotime($item->created_at)) }}
                                </td>
                                <td>{{ $item->order_no }}</td>
                                <td>
                                    {{ $item->showroom?$item->showroom->name_eng:'N\A' }}
                                </td> 
                              
                                <td>{{ $item->warehouse?$item->warehouse->name_eng:'' }}</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>
                                    {{ ($item->delivery_status==2?'DELIVERED':($item->delivery_status==0?'PENDING':'REJECTED')) }}
                                </td>
                                <td>
                                    @if(($item->approve_status==2))
                                        <button type="button" class="btn btn-sm btn-success">Approved</button>
                                    @else
                                        {!! getApprovalInputField($item->id,801) !!}
                                    @endif
                                </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(checkAuthPermission('order.edit'))
                                        @if ($item->delivery_status == 0)
                                            <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>
                                            <button type="button" class="btn btn-sm btn-danger" onclick="setApproved({{$item->id}},1)" id="reject_{{ $i }}">Reject</button>
                                        @elseif ($item->delivery_status == 1)
                                            <button type="button" class="btn btn-sm btn-warning" onclick="setApproved({{$item->id}},0)">Restore</button>
                                        @endif
                                    @endif
                                </td>
                            </tr>
                            @empty
                            <tr><td colspan="9" class="text-center text-danger">{{'THERE IS NO ORDER YET '.strtoupper($zone->name).' '.($zone->type==5?'REGION':'ZONE')}}</td></tr>
                            @endforelse
                            @php $total+=$wareAmount; @endphp
                            <tr><td class="text-right text-dark" colspan="5"><strong>{{'Total : '}}</strong></td><td class="text-right"><strong>{{number_format($wareAmount,2)}}</strong></td><td colspan="4"></td></tr>
                             
                        @empty
                           
                        @endforelse
                        @php
                            $transactions=$orders->whereNotIn('id',$isOrderShowedShopWise)->where('transaction_type',14);
                        @endphp
                        <tr>
                            <td class="text-center text-dark" colspan="10"><strong>THIS STORE</strong></td>
                        </tr>
                        @forelse ($transactions as $i=>$item)
                        <tr id="tr{{$p}}">
                            <td> {{ ($p++) }}</td>
                            <td>
                                {{ date('d-M-Y h:i A',strtotime($item->created_at)) }}
                            </td>
                            <td>{{ $item->order_no }}</td>
                            <td>
                                {{ $item->showroom?$item->showroom->name_eng:'N\A' }}
                            </td> 
                            <td>{{ $item->warehouse?$item->warehouse->name_eng:'' }}</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>
                                {{ ($item->delivery_status==2?'DELIVERED':($item->delivery_status==0?'PENDING':'REJECTED')) }}
                            </td>
                            <td>
                                @if(($item->approve_status==2))
                                    <button type="button" class="btn btn-sm btn-success">Approved</button>
                                @else
                                    {!! getApprovalInputField($item->id,801) !!}
                                @endif
                            </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
                        <tr><td colspan="10" class="text-center text-danger">{{'THERE IS NO ORDER YET FOR THIS STORE'}}</td></tr>
                        @endforelse
                        <tr><td class="text-right text-dark" colspan="5"><strong>{{'Grand Total : '}}</strong></td><td class="text-right"><strong>{{number_format($total,2)}}</strong></td><td colspan="4"></td></tr>
                    </tbody>
                </table>
            </div> 
            <hr> 
            <div class="row pb-0  modal-footer">
                <input class="btn-sina-submit" type="submit" id="save" value="DELIVER" onclick="return confirm('are you sure?');">
            </div>
        {{-- </form> --}}
    </div>
</div>
</form>
@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