@extends('layouts.backend')

@section('extraCss')
<style>
    .select2-container--open .select2-dropdown--below {
        min-width:200px !important;
    }
    .tblPosOrdList td, .tblPosOrdList th {
        font-size:12px;
    }
    .site-footer {
    position: relative!important;
  }
</style>
@endsection
@php  
     $reqpos = request("pos_id");
@endphp

@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4>
            Manage SIS Sale Orders
             <a class="btn btn-info float-right btn-sm" type='button'  data-toggle="modal" data-target="#centralModal"><i class="fa fas fa-upload"></i> Upload Sales </a>

             <a class="btn btn-info float-right btn-sm" type='button'  data-toggle="modal" data-target="#RTVModal" style="margin-right:20px;"><i class="fa fas fa-upload"></i> Upload RTV</a>
            
        </h4>
    </div>
    <div class="card-body">
        <div class="alert alert-default">
            <form action="{{  route('centralStore.index') }}">
                <h4>Filter </h4>
                <table class="table filterPosSo">
                    <tr>
                        <td width="100">REF NO#</td>
                        <td width="150">Group</td>
                        <td width="150">Store</td>                        
                        <td width="150">DATE FROM</td>
                        <td width="150">DATE TO</td>
                        <td width="100">OUTWARD</td>
                        <td width="100">DELIVERED</td>
                        <td width="100">INWARDED</td>                        
                        
                        <td colspan="2">ACTION</td>
                    </tr>
                    <tr>
                        <td>
                            <input name="manual_ref_no" id="manual_ref_nos" class="form-control" value="{{ request('manual_ref_no') }}" style="width:100px;">
                        </td>
                        <td>
                            {{-- <select name="from_pos" id="from_pos" class="select2"  style="width:150px;">
                                <option value="">Any</option>
                                @foreach($ALL_WAREHOUSES as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select> --}}
                            <select name="storeType[]" id="storeType" class="input-md" style="width:10%;"  multiple="multiple">                                                      
                                @foreach($ALL_GROUP as $key => $type)
                                @if($type->id != 1 && $type->id != 5)
                                <option value="{{ $type->id }}" {{ ( !empty(request("storeType")) && in_array($type->id , request("storeType")) ? "selected" : "")  }}
                                {{ ( empty(request("storeType")) ? "selected" : "") }}>{{ $type->name }}</option>
                                @endif
                                @endforeach
                                </select>
                        </td>
                        <td>
                            <select name="pos_id[]" id="posStore" class="input-md" multiple="multiple" style="width:10%;">
                            </select>
                        </td>
                       
                        <td>
                            <input name="datefrom" id="datefrom" class="form-control datepicker" value="{{ request('datefrom') }}" style="width:auto;">
                        </td>
                        <td>
                            <input name="dateto" id="dateto" class="form-control datepicker" value="{{ request('dateto') }}" style="width:auto;">
                        </td>                      

                        <td>
                            <select name="outward" id="outwards" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('outward') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('outward') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td>
                            <select name="delivered" id="delivered" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('delivered') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('delivered') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        
                        <td>
                            <select name="inward" id="inward" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('inward') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('inward') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td><button class="btn btn-block btn-success"><i class="fa fas fa-search"></i></button></td>
                        <td><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('centralStore.index') }}';"><i class="fa fas fa-refresh"></i></button></td>
                    </tr>
                </table>
            </form>
        </div>
        <table class="table table-bordered tblPosOrdList">
            <thead>
                <tr>
                    <th>REF#</th>
                    <th>Sales Refrence No.</th>
                    <th>FROM</th>
                    <th>TO</th>
                    <th>Order DATE</th>
                                  
                    <th>Order Qty</th>
                    <th>Outward Qty</th>
                    <th>Inward Qty</th>                    
                    <th>OUTWARD</th>
                    <th>DELIVERED</th>   
                    <th>INWARDED</th>                 
                    
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                @if($posSalesOrders->count() > 0)
                @php $gouttotal = 0; @endphp
                @foreach($posSalesOrders as $posSalesOrder)
                <tr>
                    <td>{{ $posSalesOrder->in_ref_no }}</td>
                    <td>
                        <input type="hidden" name="orderID" id="orderId" class="orderId"  value="{{ $posSalesOrder->id }}">
                        @if($posSalesOrder->pre_account==1 && $posSalesOrder->accounts == 1)
                        <input name="accdate" id="accdate{{ $posSalesOrder->id  }}" class="form-control datepicker" value="{{ $posSalesOrder->sales_inward_date }}" >                       
                        <input type="text" name="sales_ref_no" id="sales_ref_no" class="sales_ref_no" data-oid={{ $posSalesOrder->id  }} value=" {{ !empty($posSalesOrder->sales_ref_no) ? $posSalesOrder->sales_ref_no : ''  }}">                        
                      
                        @endif
                    </td>
                    <td>{{ $posSalesOrder->warehouse->name }}</td>
                   
                    <td>{{ !empty($posSalesOrder->mwarehouse->name) ? $posSalesOrder->mwarehouse->name : $posSalesOrder->party->name }}</td>
                    
                    <td>{{ $posSalesOrder->order_date }}</td>
                    
                    <td>{{ $posSalesOrder->items->sum('qty') }}</td>
                    <td>{{ $posSalesOrder->items->where('outward', 1)->sum('qty') }}</td>
                    <td>{{ $posSalesOrder->items->where('inwarded', 1)->sum('qty') }}</td>          
          
                    <td>{{ empty($posSalesOrder->outward) ? 'No' : 'Yes' }}</td>
                    <td>{{ empty($posSalesOrder->accounts) ? 'No' : 'Yes' }}</td>
                    <td>{{ empty($posSalesOrder->inward) ? 'No' : 'Yes' }}</td>
                    
                 
          
                    <td width="100">
                        <div class="dropdown">
                            <button type="button" class="btn btn-primary btn-sm btn-block dropdown-toggle" data-toggle="dropdown">
                              Actions
                            </button>
                            <div class="dropdown-menu">                            
                              
                             <a class="dropdown-item" href="{{ route('centralStore.inward',['id' => $posSalesOrder->id]) }}" onclick="return confirm('Are you sure you want to inward this sales order?');"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-upload"></i> Inward</small></a>

                             

                              {{-- <a class="dropdown-item" target=_blank href="{{ route('exportPdf',['id' => $posSalesOrder->id,'act'=>'print-so-order-slip']) }}" ><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Order Slip</small></a>

                              <!--a class="dropdown-item" href="#" onclick="$('#so_id2').val({{ $posSalesOrder->id }});document.sofrm2.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Invoice</small></a-->
                             <a class="dropdown-item" target=_blank href="{{ route('exportPdf',['id' => $posSalesOrder->id,'act'=>'print-so-invoice']) }}" ><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Invoice PDF</small></a>

                              <a class="dropdown-item" href="#" onclick="$('#so_id3').val({{ $posSalesOrder->id }});document.sofrm3.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Invoice XLS</small></a>
                              <!--a class="dropdown-item" href="#" onclick="$('#sortage_id').val({{ $posSalesOrder->id }});$('#actstorage').val('print-so-sortage-slip');document.sortagefrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Sortage Order</small></a-->

                              <a class="dropdown-item" target=_blank href="{{ route('exportPdf',['id' => $posSalesOrder->id,'act'=>'print-so-sortage-slip']) }}"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Sortage Order</small></a>

                              <!--a class="dropdown-item" href="#" onclick="$('#preinvoice_id').val({{ $posSalesOrder->id }});$('#preinvoice').val('print-pre-invoice-slip');document.preinvoicefrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Pre Invoice</small></a-->

                                <a class="dropdown-item" target=_blank href="{{ route('exportPdf',['id' => $posSalesOrder->id,'act'=>'print-pre-invoice-slip']) }}" ><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Pre Invoice</small></a>
                              <a class="dropdown-item" target=_blank href="{{ route('exportPdf',['id' => $posSalesOrder->id,'act'=>'sortage-avail-stock-slip']) }}" ><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Available Sortage Order</small></a>

                               --}}
                             
                            </div>
                        </div>
                       
                    </td>
                </tr>
                @endforeach
                @else
                <tr>
                    <td colspan="10"><div class="alert alert-danger">No sale order found!</div></td>
                </tr>
                @endif
            </tbody>
        </table>
        
        <div class="text-right">
            {!! $posSalesOrders->render() !!}
        </div>
    </div>
</div>
<!-- The Modal -->
<div class="modal" id="centralModal">
    <div class="modal-dialog">
      <div class="modal-content">
  
        <!-- Modal Header -->       

        <div class="modal-header text-center">
          <h4 class="modal-title w-100 font-weight-bold"> Upload SIS Sales Excel</h4>
          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
  
        <!-- Modal body -->
        <div class="modal-body">           
                <form method="POST" action = "{{ route('import') }}" enctype="multipart/form-data" id="laravel-ajax-file-upload" action="javascript:void(0)" >
                <div class="row">
                  <div class="col-md-12">
                      
                      <div class="form-group"><label for="hsnname">File</label><input type="file" class="form-control" name="uploaddata"  required value="" placeholder="Upload the txt file for barcodes"/></div>
                        <div class="form-group">
                            <button class="btn btn-block btn-primary"  type="submit">Save Sales Order</button>
                            
                        </div>
                        <div class="form-group">
                            <a href="{{ route('download-excelformate',['sales-excel.txt']) }}" class="btn btn-block btn-success" target="_blank">Download File Format</a>
                            <h6>Steps:</h6>
                            <ol>
                                <li>Download the text file from the Download File Format Button above</li>
                                <li>Open the file with Excel</li>
                                <li>Fill in the store code,barcode,mrp,qty,grosssell,netsell</li>
                                <li>Upload the File</li>
                                <li>Remove blank space from top and bottom</li>
                            </ol>
                        </div>
                        
                  </div>
                </div>
           
        </div>
  
        <!-- Modal footer -->
        <div class="modal-footer">
          <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
        </div>
  
      </div>
    </div>
</div>
<!-- The Modal -->

<!-- The Modal -->
<div class="modal" id="RTVModal">
    <div class="modal-dialog">
      <div class="modal-content">
  
        <!-- Modal Header -->       

        <div class="modal-header text-center">
          <h4 class="modal-title w-100 font-weight-bold"> Upload SIS RTV Excel</h4>
          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
  
        <!-- Modal body -->
        <div class="modal-body">           
                <form method="POST" action = "{{ route('import') }}" enctype="multipart/form-data" id="laravel-ajax-file-upload" action="javascript:void(0)" >
                <div class="row">
                  <div class="col-md-12">
                      
                      <div class="form-group"><label for="hsnname">File</label><input type="file" class="form-control" name="uploaddata"  required value="" placeholder="Upload the txt file for barcodes"/></div>
                        <div class="form-group">
                            <button class="btn btn-block btn-primary"  type="submit">Save RTV Order</button>
                            
                        </div>
                        <div class="form-group">
                            <h6>Steps:</h6>
                            <ol>
                                <li>Make the Consolidate excel </li>
                                <li>Remove Total row from bottom</li>                                
                                <li>Upload the File</li>
                            </ol>
                        </div>
                        
                  </div>
                </div>
           
        </div>
  
        <!-- Modal footer -->
        <div class="modal-footer">
          <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
        </div>
  
      </div>
    </div>
</div>
<!-- The Modal -->

@endsection

@section('extraJs')
<script type="text/javascript">
   

    $(document).ready(function() {   
            var type = $('#storeType').val();
            callstores(type);
            $("#storeType").on('change', function () { 
            var type = $('#storeType').val();
            callstores(type);
            });

            function callstores(type)
            {
                var _token   = $('meta[name="csrf-token"]').attr('content'); 
                $.ajax({
                    url:"{{ route('type-store-list') }}",
                    method:"get",
                    data:{type: type, _token:_token},
                    success:function(res)
                    { 
                        if(res){ console.log(res);
                            $("#posStore").empty();

                            $.each(res,function(key,value){ //console.log(key,value);
                            $("#posStore").append('<option value="'+key+'" >'+value+'</option>');
                            });

                            console.log( null);
                            var values = null;
                            $.each(values, function(i,e){ console.log(i,e);
                                $("#posStore option[value='" + e + "']").prop("selected", true);
                            });

                            $('#posStore').multiselect({            
                                enableFiltering: true,
                                allSelectedText: 'All',
                                maxHeight: 200,
                                includeSelectAllOption: true,
                                enableCaseInsensitiveFiltering: true  
                            });        

                            $('#posStore').multiselect('rebuild');

                        }else{
                            $("#posStore").empty();
                        }
                    }
                })
            }
    });

    $(document).ready(function(){
          $(".sales_ref_no").change(function(){
            var _token   = $('meta[name="csrf-token"]').attr('content'); 
            var orderId=$(this).attr('data-oid');
            var order_no=$(this).val();
            var accdate = $('#accdate'+orderId).val();
            
            $.ajax({
                    method: 'POST',
                    url: '{{ route('update-sales-ref-no') }}',
                    data: '_token=' + document.tokenForm._token.value + '&orderId=' + orderId + '&order_no=' + order_no + '&accdate=' + accdate,
                    success: function(result) {
                                var response = jQuery.parseJSON(result);                
                                if(response.status == false) {
                                    toastr.error(response.info);
                                } else {                                            
                                    toastr.success(response.info);
                                        location.reload();                            
                                    }                         
                    }
                });  
          });
    });
</script>
@endsection