@extends('layouts.backend') @section('extraCss') @endsection @php $spscount = 0; $spcCustomer = \DB::table('oc_customer_ref')->select('customer_id')->where('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(); } $storesType = [ 1 => 'Suti' , 2 => 'Central' , 3 => 'Shopper' ]; $reqpos = request("pos_id"); @endphp @section('mainContentArea')