Check conflicts for time span groups

gistfile1.txt

private function checkConflicts(array $daysOfWeek, array $timeSpan, $callQueueGroupId, $callQueueGroupTimeSpanId = null)
    {
        $conflicts =  0;

        if ($callQueueGroupTimeSpanId) {

            foreach ($daysOfWeek as $dayOfWeek) {

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('id', '!=', $callQueueGroupeTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('id', '!=', $callQueueGroupeTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '>=', $timeSpan['start'])
                    ->where('end', '<=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('id', '!=', $callQueueGroupeTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['start'])
                    ->count();

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('id', '!=', $callQueueGroupeTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('end', '>=', $timeSpan['end'])
                    ->where('start', '<=', $timeSpan['end'])
                    ->count();
            }

        } else {

            foreach ($daysOfWeek as $dayOfWeek) {

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '>=', $timeSpan['start'])
                    ->where('end', '<=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['start'])
                    ->count();

                $conflicts += CallQueueGroupTimeSpan::where('call_queue_group_id', $callQueueGroupId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('end', '>=', $timeSpan['end'])
                    ->where('start', '<=', $timeSpan['end'])
                    ->count();
            }

        }

        return $conflicts;

    }