Check cconflicts for time spans

gistfile1.txt

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

        if ($callQueueTimeSpanId) {

            foreach ($daysOfWeek as $dayOfWeek) {

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('id', '!=', $callQueueTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('id', '!=', $callQueueTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '>=', $timeSpan['start'])
                    ->where('end', '<=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('id', '!=', $callQueueTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['start'])
                    ->count();

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('id', '!=', $callQueueTimeSpanId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('end', '>=', $timeSpan['end'])
                    ->where('start', '<=', $timeSpan['end'])
                    ->count();
            }

        } else {

            foreach ($daysOfWeek as $dayOfWeek) {

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '>=', $timeSpan['start'])
                    ->where('end', '<=', $timeSpan['end'])
                    ->count();

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('start', '<=', $timeSpan['start'])
                    ->where('end', '>=', $timeSpan['start'])
                    ->count();

                $conflicts += CallQueueTimeSpan::where('call_group_id', $callQueueId)
                    ->where('dayOfWeek', $dayOfWeek)
                    ->where('end', '>=', $timeSpan['end'])
                    ->where('start', '<=', $timeSpan['end'])
                    ->count();
            }

        }

        return $conflicts;

    }