static function getScheduleCountForBatch($batchId, $startDate, $endDate) { $batchEndDate = Batches::select('end_date')->where("id", "=", $batchId)->get(); //$batchEndDate['0']->end_date; /* BatchSchedule::where('batch_id', '=', $batchId) ->whereBetween('schedule_date', array($startDate, $endDate)) ->count(); print_r(DB::getQueryLog()); exit(); */ return BatchSchedule::where('batch_id', '=', $batchId)->whereBetween('schedule_date', array($startDate, $endDate))->count(); }