@extends('layouts.backend')

@section('extraCss')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedheader/3.1.2/css/fixedHeader.dataTables.min.css">
<link href="https://cdn.datatables.net/buttons/1.7.0/css/buttons.dataTables.min.css" rel="stylesheet">
<style type="text/css">
.card-header{
        border-bottom-style:hidden !important;
    }
</style>
@endsection

@php 
       $spscount = 0;
       $spcCustomer = \DB::table('oc_customer_ref')->select('customer_id')->whereIn('warehouse_id', $pos_id)->get();    

       foreach ($spcCustomer as $key => $value) { 
          $spsCustomersCollection[] = $value->customer_id;
        }
        if(!empty($spsCustomersCollection)){
       $spscount = \DB::table('oc_plan_to_customer')->where('current',1)
       ->where('status',1)->whereBetween('start_date', [$startdate, $enddate])->whereIn('customer_id', $spsCustomersCollection)->count();
      }
        
@endphp

@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4>Sales With Gst Summary Report  </h4>
    </div>     

    <div class="alert alert-default " style="overflow-x:auto;">
            <form action="{{ route('pos-daily-sales-summary-with-gst-report') }}" id="productreport">
                <h4>Filter  </h4>
                <div style= "padding:15px;">
                        <label><input type="checkbox" value="range" name="filterby" checked> Date Range </label>
                        <label><input type="checkbox" value="month" name="filterby"> Month </label>                                             
                </div>                

                <table class="table filterPosSo">
                     
                    <tr>
                        <td width="15%">Warehouse</td>
                        <td width="15%">Store</td>
                        <td width="10%" id="sdate">Start Date</td>
                        <td width="10%" id="edate">End Date</td>                    
                        <td colspan="2">ACTION</td>
                    </tr>
                    <tr>  
                         <td>
                            <select name="pos_id[]" id="warehouse" class="input-md"  multiple="multiple" >
                                
                                @foreach($ALL_WAREHOUSES as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ ( !empty(request("pos_id")) && in_array($warehouse->id, request("pos_id")) ? "selected" : "") }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>

                        <td>
                            <select name="pos_id[]" id="Pos" class="input-md"  multiple="multiple">                                
                                @foreach($ALL_POS as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ ( !empty(request("pos_id")) && in_array($warehouse->id, request("pos_id")) ? "selected" : "") }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>                      
                        <td>
                            <input type="text" name="startdate" id="startdate" readonly class="form-control datepicker" placeholder="Enter Start date" value="