query

gistfile1.txt

// Query
        $query = Lead::where([
            ['campaign_id', $request->get('campaignId')]
        ])
            ->whereBetween('submitted_date_time', [$startDateTime, $endDateTime])
            ->where(function($q) use ($analyticCampaignId_array, $trackingPhone_array, $directChannelId_array, $status)
            {
                if(!empty($analyticCampaignId_array))
                {
                    $q->orWhereIn('analytic_campaign_id', $analyticCampaignId_array)
                        ->where('type', $this->submitted_lead);
                }
                if(!empty($trackingPhone_array))
                {
                    $q->orWhereIn('tracking_phone', $trackingPhone_array)
                        ->where('type', $this->phone_lead);
                }
                if(!empty($directChannelId_array))
                {
                    $q->orWhereIn('direct_channel_id', $directChannelId_array)
                        ->where('type', $this->direct_lead);
                }
            });